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?
Best answer by Troy Tessalone
Hi
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
NOTE: The Airtable API has pagination with a max of 100 records per page.
+14Hi
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
NOTE: The Airtable API has pagination with a max of 100 records per page.
Hi
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 
?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
