Skip to content
  • Google Forms logoGoogle Forms logo
  • Google Sheets logoGoogle Sheets logo
  • IP2Location IO logoIP2Location IO logo

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

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Polling
    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
    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

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.

Related categories

Triggers & Actions