Hello all, after 3 days of trying to figure this out I’m at a loss.
I’m trying as the title says to update a google sheet when any row in a particular table in mysql is updated. I have the zap set up without errors yet it does not fire or trigger when the mysql table has been updated (which is the trigger). I have read through just about everything on the help site. Important notes:
- MySQL version is 5 something (under v8 in the help section)
- I understand there is lag from the time mysql updates
- The table I’m using in mysql does not have a date column that specifies when a row was updated
I think my zap error may reside in the 3rd step, under the Row portion, I have selected what I think is a lookup variable in 2. Row:3 by choosing Or add search step (this portion of the zap explains “If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.” I have done this and selected 2. Row:3 because that is the only thing I see in the google sheet that is not an actual name of a header row in the google sheet. As mentioned the zap is not throwing any errors after I go through the process yet nothing is firing.
Any help would be greatly appreciated. Screen captures are provide.
