Enrich emails from new Google Forms responses with ESPY and update Google Sheets rows
Automatically enrich email addresses submitted via Google Forms using ESPY's email search. This template will fetch additional information such as other email addresses, names, social network accounts, disposable email status, and trust score, then update a Google Sheet with the enriched data. This process ensures you have comprehensive and accurate data at your fingertips.
Automatically enrich email addresses submitted via Google Forms using ESPY's email search. This template will fetch additional information such as other email addresses, names, social network accounts, disposable email status, and trust score, then update a Google Sheet with the enriched data. This process ensures you have comprehensive and accurate data at your fingertips.
- When this happens...New Form Response
Triggers when a new form response is received.
- automatically do this...Email Search Lookup
Fetches detailed information about the provided email address, such as associated names, social network accounts, disposable email status, and trust scores.
- then do this...Text
Work with text data to find & replace, capitalize, remove HTML, and more (with line-item support).
- 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
FormRequired
Try ItHTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
EmailRequired
Email Search LookupIdRequired
Phone NumberRequired
FormRequired
Try ItExpected NameRequired
Phone NumberRequired
Name validation Lookup IDRequired
Lookup TypeRequired
Facebook IDRequired
Name Validation Lookup IDRequired
TransformRequired