My Automation wont turn on even though test works

[Alex_Doucette]

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?

[Justin_Barrett]

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]

@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]

I am having the same problem @Alex_Doucette …

[edgaras]

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

[Justin_Barrett]

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.

[ScottWorld]

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]

Any known issue connected Google Sheets new row trigger?

[Andrew_Petrus]

Nevermind - “Spreadsheets in shared drives are not supported”

[ScottWorld]

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

Check out the screenshot below: