Google Forms + Google Sheets + ESPY + Formatter by Zapier

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.

  1. When this happens...
    Google FormsGoogle Forms
    New Form Response

    Triggers when a new form response is received.

    TriggerInstant
  2. automatically do this...
    ESPYESPY
    Email Search Lookup

    Fetches detailed information about the provided email address, such as associated names, social network accounts, disposable email status, and trust scores.

    ActionWrite
  3. then do this...
    Formatter by ZapierFormatter by Zapier
    Text

    Work with text data to find & replace, capitalize, remove HTML, and more (with line-item support).

    ActionWrite
  4. then do this...
    Google SheetsGoogle Sheets
    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.

    ActionSearch
  5. then do this!
    Google SheetsGoogle Sheets
    Update Spreadsheet Row(s)

    Update one or more new rows in a specific spreadsheet (with line item support).

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • FormRequired

    Trigger
    Instant
    Try It
    • HTTP MethodRequired

    • URLRequired

    • Query String Parameters

    • Headers

    • Additional Request Headers

    • Body

    Action
    Write
    • EmailRequired

    • Email Search LookupIdRequired

    Action
    Write
    • Phone NumberRequired

    Action
    Write
    • FormRequired

    Trigger
    Instant
    Try It
    • Expected NameRequired

    • Phone NumberRequired

    • Name validation Lookup IDRequired

    Action
    Write
    • Lookup TypeRequired

    • Facebook IDRequired

    • Name Validation Lookup IDRequired

    Action
    Write
    • TransformRequired

    Action
    Write
google-forms logo
google-forms logo

About Google Forms

Google Forms is an easy way to collect data from the web with a simple UI and powerful editor. Works hand-in-hand with Google Sheets!
Learn moreHelp

Related categories

  • Forms & Surveys
  • Google

Similar apps

Zapier Interfaces integrationsZapier Interfaces integrations

Zapier Interfaces

App Builder, CRM (Customer Relationship Management), Forms & Surveys, Zapier
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Learn moreHelp

Related categories

  • Google
  • Spreadsheets

Similar apps

Zapier Tables integrationsZapier Tables integrations

Zapier Tables

Databases, Spreadsheets, Zapier
Zoho Creator integrationsZoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrationsSmartsheet integrations

Smartsheet

Spreadsheets
espy logo
espy logo

About ESPY

ESPY is a comprehensive tool for validating phone numbers, verifying customer identities, and leveraging API endpoints for data enrichment and fraud prevention.
Help

Related categories

  • Security & Identity Tools
formatter logo
formatter logo

About Formatter by Zapier

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.
Learn moreHelp

Related categories

  • Documents
  • Zapier