Help

My Automation wont turn on even though test works

Topic Labels: Automations
3838 12
cancel
Showing results for 
Search instead for 
Did you mean: 
Alex_Doucette
4 - Data Explorer
4 - Data Explorer

I have an automation that won’t turn on despite working correctly the last few days. It’s set to create a record when a row is added to a google sheet. Both the trigger and action pass their test, yet the automation won’t turn on. What could I possibly be missing?

12 Replies 12

Welcome to the community, @Alex_Doucette! :grinning_face_with_big_eyes: Try restarting your browser (or the desktop app if that’s what you’re using). Sometimes Airtable flakes out in tiny ways, and a refresh can sometimes fix it. If that doesn’t do it, you’ll need to contact Airtable support directly.

Alex_Doucette
4 - Data Explorer
4 - Data Explorer

@Justin_Barrett Thanks. I restarted and unfortunately nothing changed. I’ve also tried recreating the automation several times with no change. I sent a loom to support so hopefully they have some insight

Kevin_Hughes
4 - Data Explorer
4 - Data Explorer

I am having the same problem @Alex_Doucette

edgaras
5 - Automation Enthusiast
5 - Automation Enthusiast

I am experiencing the same issue! Same on several different browsers.

Double-check that something didn’t change that affects the trigger step. I had something similar occur recently, and it turned out to be related to a change that I’d made to some field’s output, or maybe it was the name of a field (I forget which). Whatever it was, I couldn’t turn on the automation. Once I cleared out the settings of the trigger step and rebuilt it from scratch, it worked.

Yes, building upon what @Justin_Barrett just said, you may also need to re-test your trigger again, too, in order to get it to work.

Airtable will remember that the previous test “ran successfully” even if you change something about your trigger criteria that might make it now fail.

Andrew_Petrus
5 - Automation Enthusiast
5 - Automation Enthusiast

Any known issue connected Google Sheets new row trigger?

Nevermind - “Spreadsheets in shared drives are not supported”

Just an FYI that Make.com supports shared drives for its Google Sheets integrations & automations.

Check out the screenshot below:

Screen Shot 2022-09-21 at 10.57.41 AM