Look up IPs from one Google Sheet (via IP2Location) and store them on another worksheet
Google Sheets + IP2Location
IP2Location
IP2Location
Developer Tools
Categories
IP2Location is a non-intrusive geo IP solution to help you to identify a visitor's geographical location.
By signing up, you agree to Zapier’s Terms of Service
IP2Location Integrations
Do more with IP2Location
Zapier allows you to instantly connect IP2Location with 3,000+ apps to automate your work and find productivity super powers.
Choose an app to connect with IP2Location
Google Sheets
Google +1
Google, Spreadsheets
Unbounce
Forms & Surveys
SQL Server
Databases +1
Databases, Premium
Airtable
Databases
Gravity Forms
Forms & Surveys +1
Forms & Surveys, WordPress
PostgreSQL
Databases +1
Databases, Premium
MySQL
Databases +1
Databases, Premium
Amazon DynamoDB
Amazon +2
Amazon, Databases, Premium
ConvertFlow
Beta +1
Beta, Forms & SurveysMongoDB
DatabasesWufoo
Forms & SurveysSurvey Anyplace
Forms & SurveysAmazon SQS
Amazon +2
Amazon, Developer Tools, PremiumJotForm
Forms & SurveysClickFunnels
Marketing AutomationCognito Forms
Forms & SurveysLeadformly
Forms & SurveysInstapage
Forms & SurveysNinja Forms
Forms & Surveys +1
Forms & Surveys, WordPressSurveyMonkey
Forms & SurveysMailchimp
Email NewslettersOptinMonster
Forms & SurveysNetlify
Website BuildersWPForms
Forms & Surveys +1
Forms & Surveys, WordPressQuestionPro
Forms & SurveysShopify
eCommerce +1
eCommerce, PremiumFormsite
Forms & SurveysSendFox
Email NewslettersSlack
Team ChatFacebook Lead Ads
Ads & Conversion +2
Ads & Conversion, Facebook, PremiumActiveCampaign
Marketing AutomationTypeform
Forms & SurveysWooCommerce
eCommerce +1
eCommerce, WordPressDrip
Drip EmailsMailparser
EmailLandbot
Marketing AutomationAdalo
App BuilderWebflow
Website BuildersZoho Creator
App Builder +1
App Builder, ZohoZoho CRM
CRM (Customer Relationship Management)Â +2
CRM (Customer Relationship Management), Premium, ZohoFormstack
Forms & SurveysManyChat
Social Media MarketingGmail
Email +1
Email, GoogleStripe
Payment ProcessingGoogle Forms
Forms & Surveys +1
Forms & Surveys, GoogleToggl
Time Tracking SoftwareYouCanBook.Me
Scheduling & BookingFreshsales
CRM (Customer Relationship Management)WhatConverts
CRM (Customer Relationship Management)Glide
App Builder +1
App Builder, BetaGoogle Calendar
Calendar +1
Calendar, GoogleCalendly
Scheduling & BookingSalesforce
CRM (Customer Relationship Management)Â +1
CRM (Customer Relationship Management), PremiumPayPal
Payment Processing +1
Payment Processing, PremiumPaperform
Forms & SurveysPipelineDeals
CRM (Customer Relationship Management)noCRM.io
CRM (Customer Relationship Management)Discord
Team ChatAsana
Project ManagementGoogle Contacts
Contact Management +1
Contact Management, GoogleKajabi
eCommerceMicrosoft Excel
Microsoft +1
Microsoft, SpreadsheetsTeachable
Online CoursesIntercom
Customer SupportPodio
Project ManagementClickSend SMS
Phone & SMSDubsado
CRM (Customer Relationship Management)GetResponse
Marketing +1
Marketing, Marketing AutomationWebinarJam / EverWebinar
WebinarsSendinblue
Email NewslettersOntraport
Marketing AutomationHubSpot
Marketing AutomationAgile CRM
CRM (Customer Relationship Management)Autopilot
Marketing AutomationGumroad
eCommerceSharpSpring
Marketing AutomationFormidable Forms
Forms & Surveys +1
Forms & Surveys, WordPressPardot
Marketing Automation +1
Marketing Automation, PremiumZoho Mail
Email +1
Email, ZohoKnack
DatabasesAmazon S3
Amazon +2
Amazon, File Management & Storage, PremiumSumo
Ads & ConversionDocSend
Ads & ConversionWP All Export Pro
Website BuildersLeadfeeder
CRM (Customer Relationship Management)Chatfuel
Social Media MarketingRunrun.it
Project ManagementFormKeep
Forms & SurveysPipedrive
CRM (Customer Relationship Management)Nozbe
Task ManagementPingdom
Server MonitoringNamely
HR Talent & Recruitment +1
HR Talent & Recruitment, PremiumClose
CRM (Customer Relationship Management)Wootric
Forms & SurveysCallexa Feedback
Forms & SurveysKeap Max Classic
Marketing Automation +1
Marketing Automation, PremiumQblinks
DevicesDPD
eCommerceRecurly
eCommerce +1
eCommerce, Payment ProcessingFlic
DevicesSquare
Payment ProcessingMailMunch
Marketing AutomationMSGHero
Social Media MarketingAdafruit IO
Beta +1
Beta, DevicesLeadpages
Forms & SurveysThrive Themes
Website BuildersJoonbot
Beta +1
Beta, MarketingPrefinery
Marketing AutomationAcuity Scheduling
Scheduling & BookingFirebase / Firestore
DatabasesUPilot
CRM (Customer Relationship Management)Magentrix
Beta +1
Beta, CRM (Customer Relationship Management)Connect IP2Location to 3,000+ Apps
Connect IP2Location to...
Get IP2Location data for IP addresses from new AWS DynamoDB items and store them in another table
Amazon DynamoDB
Look up IP addresses from one Amazon SQS message using IP2Location and add the results to a different queue
Amazon SQS
Query IP2Location for IPs stored in new MySQL and add geolocation data to a new table row
MySQL
Capture IP data from a new SQL Server row (via IP2Location) and add it to a different table
SQL Server
Capture IP data from a new PostgreSQL row (via IP2Location) and add it to a different table
PostgreSQL
The following IP2Location Triggers, Searches, Filters, and Actions are supported by Zapier:
Searches
- Lookup IP Address by Package
Finds geolocation info about an IP address like city, country, timezone. Select package for varying levels of information.
Connect the apps you use every day
Get started with a Free account
By signing up, you agree to Zapier’s Terms of Service