Skip to content
  • Google Forms logoGoogle Forms logo
  • Google Sheets logoGoogle Sheets logo
  • Formatter by Zapier logoFormatter by Zapier logo

Google Forms + Google Sheets + 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...
     logo logo
    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 rows in a specific spreadsheet (with line item support).

    ActionWrite
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

    • FormRequired

    Trigger
    Instant
    Try It
    • Api Docs Info

    • Stop on errorRequired

    • HTTP MethodRequired

    • URLRequired

    • Query string parameters

    • Additional request headers

    • Body

    Action
    Write
    • TransformRequired

    Action
    Write
    • TransformRequired

    Action
    Write
    • FormRequired

    Trigger
    Instant
    Try It
    • TransformRequired

    Action
    Write
    • TransformRequired

    Action
    Write
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Polling
    Try It
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!

Related categories

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.

Related categories

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.

Related categories

Triggers & Actions