Google Sheets + SureConnect + Looping by Zapier
Update Google Sheets rows with SureConnect verification results
Keep your contact records up to date without manual data entry. When a new contact is verified in SureConnect, the results are automatically fetched from SureConnect servers and matched using the unique ID in a connected Google Sheets spreadsheet before being updated, with no added clicks or keystrokes.
Keep your contact records up to date without manual data entry. When a new contact is verified in SureConnect, the results are automatically fetched from SureConnect servers and matched using the unique ID in a connected Google Sheets spreadsheet before being updated, with no added clicks or keystrokes.
- When this happens...Contact Verified
Triggers when contacts are verified.
- automatically do this...Get Verification Result
Fetch the result for the completed Contacts
- then do this...Create Loop From Text
Creates a new Loop from text value(s) with a specified delimiter. This is an advanced action!
- then do this...Lookup Spreadsheet Row
Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.
- then do this!Update Spreadsheet Row(s)
Update one or more new rows in a specific spreadsheet (with line item support).
- Free forever for core features
- 14 day trial for premium features & apps
Contact Verified
Triggers when contacts are verified.
Try ItContact NameRequired
Company Name
Phone Number 1Required
Phone Number 2
Phone Number 3
Help Warning
Values to LoopRequired
Trim Whitespace
Loop iteration counter start
Maximum number of Loop iterations
Help Warning
Values to LoopRequired
Text Delimiter
Trim Whitespace
Loop iteration counter start
Maximum number of Loop iterations
Unique Contact IDsRequired
Contact NameRequired
Company Name
Phone Number 1Required
Phone Number 2
Phone Number 3
Help Warning
Loop iteration counter start
Loop iteration counter end
Loop iteration counter increment amount
Maximum number of Loop iterations
Drive
SpreadsheetRequired
WorksheetRequired
Try It
