My client has a WordPress site that uses Gravity forms. I'm using Zapier so that each time a new submission is entered into the form, it adds this information as a new row in a Google Spreadsheets (
Everything is working, but from there this data gets pulled into a second Google Spreadsheet (
Client Sheet) but new entries in the
Master Sheet are not picked up by the
Client Sheet unless there is some form of human action on the
Master Sheet. In other words, I need to effect the
Master Sheet before the entries get pulled across to the
Client Sheet. However, if I manually add an entry to the
Master Sheet, it immediately reflects on the
So my guess is that there is some kind of edit function that gets triggered by a human user but not by an entry from Zapier.
PS. I have already tried using the script detailed in this question:
How can I get Google Sheets to auto-update a reference to another sheet?
Unfortunately I cannot get it to work.