Sign up for updates

Get a weekly update every Sunday with our announcements, company updates and a behind-the-scenes of what our community are building.
Over 11,000 people get our updates, join us!
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.
⭠ all tutorials

Auto fetch social posts of podcast guests

This tutorial is available for pro members only

Request access

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

The full tutorial is available for pro members only

Request access

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.

Steps

  • [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.

Bonus

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

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.

Steps

  • [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.

Bonus

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

Lesson details

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.

Steps

  • [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.

Bonus

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

Previous submissions
No items found.
Supporting details

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

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.

Steps

  • [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.

Bonus

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

Ready to get started?

Join the community and start turning your ideas into solutions