Loading

Google Sheets + IP2Location IO

Query geolocation data with IP2Location.io from new Google Sheets rows

This template reads IP addresses from new Google Sheets rows, then queries geolocation data from IP2Location.io. Finally, the results will be stored in Google Sheet rows.

This template reads IP addresses from new Google Sheets rows, then queries geolocation data from IP2Location.io. Finally, the results will be stored in Google Sheet rows.

  1. When this happens...
    Google SheetsGoogle Sheets
    New Spreadsheet Row

    Triggered when a new row is added to the bottom of a spreadsheet.

    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
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • No Team Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Trigger
    Instant
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    • Trigger Column

    Trigger
    Scheduled
    Try It
    • Drive

    • SpreadsheetRequired

    Trigger
    Scheduled
    Try It
    • Drive

    • SpreadsheetRequired

    • WorksheetRequired

    Action
    Write
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.

Related categories