Gravity form to look up info in a spreadsheet and add text to a cell

Hi there,

I use gravity forms and Zapier for an induction process. User completed a gravity form and captures details such as first and last name. When submitted this updates a spreadsheet row in a Google Sheet.

What I’d like to do, is similiar, but have the Zap check the gravity forms First Name and Last name fields against a pre populated Google Sheet with First and Last names plus other info. If the Zap matches the names fields it then changes/adds text to the cell on that row.

I’m trying to avoid having to check two spreadsheets - one for accreditation and the other for induction completions and bring the two into one combined spreadsheet.

Thanks you in advance of any help.

Chris

Page 1 / 1

Hi @Fiji Chris

Try these Zap steps:

Trigger: Gravity Forms - Form Submission
Action: GSheets - Lookup Row
Action: Filter
Action: GSheets - Update Row
1. Map the ID/Row from Zap step 2

Thanks for the quick reply Troy.

It’s kind of there, but all the info in the row is deleted (I need this to stay) but the cell I need the text changing to works.

Any idea how I can just update one cell, and leave the others alone?

Thanks

@Fiji Chris

For us to have more info, post screenshots showing how your Zap steps are outlined and configured in the CONFIGURE tab while in EDIT mode with the field mappings visible.

If you are using formulas in the GSheet, then that may be why only the 1 cell value is being updated.

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded