If you haven’t heard of Pabbly Connect, it’s a workflow automation service that allows you to pass data from one online service to another to perform analyses, generate reports and various other tasks. There is no coding involved; users just have to select which service to read from and what data. Then choose another service to receive the data to perform the task you want. Once you have your workflow configured and turned on, any new data on the originating service will be automatically fed to the destination service.
IP2Location.io Pabbly Connect integration
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. By using the IP2Location.io Pabbly Connect integration, users can seamlessly retrieve IP geolocation data based on IP address stored on various services like Google Sheet.
IP2Location.io Pabbly integration: https://www.pabbly.com/connect/integrations/ip2location-io/
NOTE: An IP2Location.io API key is required. Sign up for a Free IP2Location.io API key if you don’t have one.
Demo: Integrating IP2Location.io and Google Sheet via Pabbly
For our demonstration today, we’ll show how to read IP addresses from Google Sheet and sending it to IP2Location.io to retrieve the IP geolocation. Then we will store the results back into Google Sheet.
Step 1: Sign up for a Pabbly account and login. You should see the page below. Then, click on “Access Now” under Pabbly Connect.
Step 2: After clicking on “Access Now”, you’ll see the Dashboard page below:
Step 3: Click on “Create Workflow” to get started. Write a name for your workflow. We’ll call ours “Test Pabbly” and click “Create”.
Step 4: Select which application to read the IP address from. As we are going to go with Google Sheet, type “Google Sheet” into the Search field. Click on the Google Sheet app.
Step 5: After clicking on Google Sheet, you will see your first step become Google Sheet.
Step 6: Let’s configure the Trigger Event. Select “New or Updated Spreadsheet Row” for the trigger event.
Step 7: Need to configure Google Sheet so let’s create a new sheet there. We’ll call ours “Test Pabbly”. We will also put a header for the first column called “IP”.
Step 8: Let’s install the Pabbly Connect Webhooks add-on. Navigate to the “Extensions” in the menu, move to “Add-ons” option and then click on “Get add-ons”. A dialog box will appear. Now, search for the Pabbly Connect Webhooks add-on and install it.
Step 9: After installing the add-on, refresh the page. Now, add “8.8.8.8” as the first row after the header. This will be our test data.
Step 10: Navigate to the “Extensions” menu again, and click on Pabbly Connect Webhooks. Click on the “Initial Setup” option, put the Webhook URL provided above, and specify the trigger column. Then, click “Send Test”.
Step 11: You should see “Test data sent successfully”. Now, click “Submit” and close the dialog box.
Step 12: Go back to the Pabbly workflow and you should see the test results.
Step 13: Go back to the Google Sheet and create another sheet inside our “Test Pabbly”. We will have column headers IP, country_code, country_name, region_name and city_name to store our IP geolocation result.
Step 14: Head back to the Pabbly workflow and create the 2nd step which will be the IP2Location.io app. Search and select it as the 2nd step.
Step 15: Select “Look Up IP Address” as the Action Event.
Step 16: Click on “Connect” to configure the IP2Location.io API key. Key in your API key and click “Save”.
Step 17: Select the IP column from the Google Sheet as the IP Address source.
Step 18: Click “Save & Send Test Request” and you’ll see the results below:
Step 19: Create another step in the workflow to store the IP geolocation back into Google Sheet. We’ll add a new row into the 2nd sheet that we’ve created earlier.
Step 20: Click “Connect” and sign in your Google Sheet account. Give it all the permissions required. Then, select “Sheet2” and configure the fields to store the results coming from IP2Location.io.
Step 21: Click “Save & Send Test Request” and you’ll see the results stored in the Google Sheet.
Conclusion
It’s that simple to setup a Pabbly workflow to read IP addresses from Google Sheet and retrieve the corresponding IP geolocation data. Then, store the results back into Google Sheet. Our example just stores a few fields but you get the idea.
For more tutorials, please visit IP2Location
Top comments (0)