Hi! I’m trying to use Zapier to create an integration that will take entries from a Google Forms survey and 1) add new entries; 2) update existing entries (e.g. email or phone # contact) in Google Sheets.
Basically trying to use Google Sheets to store member info, and want the contact portions to get auto-updated so I don’t have to manually change pre-existing fields.
Thanks!
Best answer by andywingrave
Hey there,
Just to summarise the thread here.
You can use Google Forms which can be linked to a Google Sheet to auto add new entries.
The list of available actions via Zapier: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions
In order to auto-update existing entries, you can first perform a Lookup of the record in your first action step and then use an update spreadsheet row task as your next action (using the row ID from the Lookup step).
+14FYI: GForms can be linked to a GSheet to auto add new entries.
GSheets available actions via Zapier: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions
Thanks, Troy! Wondering how I can then auto-update existing entries though. (i.e. can it be set up to reference existing data columns and check for inconsistencies, then update the specific fields with the new info?)
+9Hey there,
Just to summarise the thread here.
You can use Google Forms which can be linked to a Google Sheet to auto add new entries.
The list of available actions via Zapier: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions
In order to auto-update existing entries, you can first perform a Lookup of the record in your first action step and then use an update spreadsheet row task as your next action (using the row ID from the Lookup step).
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
