Google Forms + Google Sheets + IP2Location IO

Query IP2Location.io for geolocation data from new Google Forms responses and create Google Sheets rows

When a user submits a new Google Form with IP info, IP2Location.io will retrieve the geolocation data. The result will be added to a Google Sheets row as well.

When a user submits a new Google Form with IP info, IP2Location.io will retrieve the geolocation data. The result will be added to a Google Sheets row as well.

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

    Triggers when a new form response is received.

    TriggerInstant
  2. automatically do this...
    IP2Location IOIP2Location IO
    Look Up IP Address

    Retrieves geolocation data for an IP address like country, region, city and more.

    ActionSearch
  3. then do this!
    Google SheetsGoogle Sheets
    Create Spreadsheet Row

    Create a new row in a specific spreadsheet.

    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
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Scheduled
    Try It
    • Drive

    Trigger
    Scheduled
    Try It
    • FormRequired

    Trigger
    Instant
    Try It
    • IP AddressRequired

    Action
    Search
    • No Team Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Instant
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Trigger Column

    Trigger
    Scheduled
    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!
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
ip2location-io logo
ip2location-io logo

About IP2Location IO

IP2Location.io provides a fast and accurate IP Geolocation API tool to determine a user's location and use the geolocation information in different use cases.
Help

Related categories

  • Developer Tools