DEV Community

Cover image for with Pabbly Connect Integration

Posted on with Pabbly Connect Integration

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. Pabbly Connect integration 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 Pabbly Connect integration, users can seamlessly retrieve IP geolocation data based on IP address stored on various services like Google Sheet. Pabbly integration:

NOTE: An API key is required. Sign up for a Free API key if you don’t have one.

Demo: Integrating and Google Sheet via Pabbly

For our demonstration today, we’ll show how to read IP addresses from Google Sheet and sending it to 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:
Pabbly dashboard

Step 3: Click on “Create Workflow” to get started. Write a name for your workflow. We’ll call ours “Test Pabbly” and click “Create”.
Create workflow

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.
Test Pabbly

Step 5: After clicking on Google Sheet, you will see your first step become Google Sheet.
Google sheet

Step 6: Let’s configure the Trigger Event. Select “New or Updated Spreadsheet Row” for the trigger event.
Pabbly Configuration

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”.
Test Pabbly

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.
Install the Pabbly Connect Webhooks add-on

Step 9: After installing the add-on, refresh the page. Now, add “” as the first row after the header. This will be our test data.
Test IP data with Pabbly

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”.
Pabbly Connect Webhooks

Step 11: You should see “Test data sent successfully”. Now, click “Submit” and close the dialog box.
Pabbly Connect Webhooks

Step 12: Go back to the Pabbly workflow and you should see the test results.
IP geolocation using Pabbly

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.
IP geolocation test

Step 14: Head back to the Pabbly workflow and create the 2nd step which will be the app. Search and select it as the 2nd step. App

Step 15: Select “Look Up IP Address” as the Action Event.
IP Address Lookup

Step 16: Click on “Connect” to configure the API key. Key in your API key and click “Save”.
IP Address Lookup

Step 17: Select the IP column from the Google Sheet as the IP Address source.
IP Address Lookup

Step 18: Click “Save & Send Test Request” and you’ll see the results below:
IP Address Lookup

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.
IP Address Lookup

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
IP Address Lookup

Step 21: Click “Save & Send Test Request” and you’ll see the results stored in the Google Sheet.
IP geolocation result


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)