Skip to main content

I have a Google Sheet with a list of 50 names and emails, which I want to register automatically every two weeks for a webinar in GoToWebinar. I’ve created a form in Webflow and when I submit this form, all those people from my Google Sheet should be registered for a webinar. 

The challenge:

I know how I could register one single person, but not how I could register ALL people from the list.


Anyone an idea?

Hi @Likamundi 

Look into using Airtable instead of GSheets.

Airtable has APIs: https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API

App APIs can be used in Zap steps with the Webhooks app: https://zapier.com/apps/webhook/integrations

 

STEPS

  1. Trigger: Schedule
  2. Action: Webhooks - GET (Airtable API)
  3. Action: Looping - Create Loop from Line Items (https://zapier.com/apps/looping/integrations)
  4. Action: GoToWebinar - Create Registrant

NOTE: The Airtable API has pagination with a max of 100 records per page.

Hi @Troy Tessalone 

Thanks very much. Airtable and Looping by Zapier sound like a good combination. Though, I wonder if it could be possible to use Looping with GSheets instead of Airtable. What do you think?

 

Thanks for your great hints!

Ah, “Get Many Spreadsheet Rows” inside GSheet is limited to max. 20 rows:

 

And I need 50 rows, so that might be the problem, right 🙂 ?

Terms & Conditions