Best answer

Can't update row in mysql with Google Sheets

  • 4 December 2022
  • 5 replies

So I made this zap, where when a cell in a specific column is changed, it send the change to the same column in the same row in the database. (the database has 3 options it can receive)

The test shows it works ok, but I do not see any chance to the database.


Will appreciate any help :)


Best answer by Troy Tessalone 5 December 2022, 18:03

View original

5 replies

Userlevel 7
Badge +14

Hi @Megaman 

Good question.

Please post detailed screenshots with how your Zap steps are configured, thanks.

Help articles about using GSheets in Zaps:

Hi @Troy Tessalone 


Thanks for chiming in so quickly!

Looks like it got sorted out for now…


I do have another question though - is Zapier checking the database for new rows on set time intervals? and can these be changed?



Userlevel 7
Badge +14


The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger

The triggers for Google Sheets are unique among Zapier triggers. When there is a trigger event in the spreadsheet, Zapier gets a notification webhook from Google about this.
After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods.
This process takes about 3 minutes overall.

While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.

@Troy Tessalone  Thanks.


How does this work when it’s from mydql to sheets?

Userlevel 7
Badge +14


All of the MySQL Zap triggers are scheduled. (see bottom screenshot)


Scheduled Zap triggers can take from 1-15 minutes to trigger depending on your Zap plan. (see top screenshot)


Check your Zap Runs to help troubleshoot: