In this tutorial I'll show you how to create a simple automation that fetchs the latest tweets from an upcoming podcast guest.

What are we wanting to build?

A process that automatically fetches recent social posts of upcoming podcast guests.

What tools will be used?

  1. Typeform
  2. Google Sheets
  3. Phantombuster
  4. Zapier

Part 1

Create a new typeform. Add simple questions that asks for the social links of your upcoming guests. Use a website URL field for the questions.

Connect your typeform to a new Google Sheet so you have somewhere to save your results.

Part 2

Next, open up Phantombuster, go to the Store, search for the Twitter, Export Tweets Phantom.

Once open you'll need to get your Twitter session ID.

Open Twitter in your browser. Right click then select inspect. Click Application and find cookies on the left. Scroll in the cookies window to find the 'auth_token' session ID. Copy that value and input into Phantombuster.

Enter the spreadsheet URL of where the Typeform results will be saved. Make sure your sheet is public.

Give Phantombuster the column title of the Twitter URLS.

Configure to run for one line only each time + to get 10 tweets per profile.

Press save.

Now back in the console and press launch.

Part 3

Next go to Zapier and create a new Zap.

Add Webhooks by Zapier as the trigger. Select Polll URL. The URL is going to be the output JSON URL of the Phantom.

Press continue and check the data comes through correctly.

Next connect Gmail and configure the email to you an email containing the Phantom CSV output URL.

Press continue, test and you're done.

Now each time someone fills in your form the Phantom will run (if you schedule) to grab the tweets and send them to you.

If you have any questions please reach out on Twitter (@tomosman) or inside the Makerpad slack channel.


  • [x]  Create a Typeform for new guests to register with.
  • [x]  Connect a Google Sheet to store the details.
  • [x]  Setup Phantombuster API automation to watch the Google Sheet for a new record.
  • [x]  Create a Webhook Trigger Zap to catch the output of the Phantombuster step.
  • [x]  Format and send an email containing the results.


  • [ ]  Multiple Phantoms for multiple social channels.
  • [ ]  Outputs combined in Parabola and output to an API.