Google form automation doesn't trigger

Original Answer:

It might be a bug with Airtable’s Google Forms automations. I would try setting this up with Make’s Google Forms automations, and see if you have better success with that.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consulting — ScottWorld 

2025 Update:

Nowadays, your #1 best bet for this is to switch away from Google Forms, and instead use Fillout’s advanced forms for Airtable because it communicates directly with Airtable and can easily do everything that you want — no extra automations needed.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to update an existing Airtable record & create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Thanks for your answer Scott ! I managed to replace my automation with a Make scenario (I already use Make for a lot of use case).