Best answer

Register people from a list to GoToWebinar

  • 15 July 2021
  • 3 replies
  • 49 views

Userlevel 1

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?

icon

Best answer by Troy Tessalone 15 July 2021, 17:34

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Userlevel 7
Badge +14

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.

Userlevel 1

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!

Userlevel 1

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 🙂 ?