Integrating URL with City and Google Sheets: A Step-by-Step Guide

Learn how to integrate URL, City, Google Sheets, and more for seamless automation. This step-by-step tutorial guides you through the entire process. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals. with Pabbly Connect.

Watch Step By Step Video Tutorial Below

1. Setting Up Google Sheets for URL and City Integration

To begin our integration process with URL and City, we first need to set up Google Sheets. In Google Sheets, create a new spreadsheet named ‘Customer Data’. This spreadsheet will include essential fields like first name, last name, email, phone number, city, state, and postal code.

Once your spreadsheet is ready, you will be able to automatically create subscribers in your Omnisend account whenever new details are added. This is a crucial step in automating your workflow using Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

After setting up your Google Sheets, the next step is to create a workflow in Pabbly Connect. Log in to your Pabbly Connect account and click on the ‘Create Workflow’ button. Name your workflow something like ‘Create Subscriber in Omnisend from Google Sheets’ to keep it organized.

In this workflow, you will set Google Sheets as the trigger application. The trigger event should be selected as ‘New or Updated Spreadsheet Row’. This means every time a new row is added or updated, it will trigger the workflow. Ensure you have the webhook URL copied from Pabbly Connect, as it will be used to connect Google Sheets.

3. Installing Pabbly Webhooks in Google Sheets

To integrate Google Sheets with Pabbly Connect, you must install the Pabbly Webhooks add-on. Go to ‘Extensions’ in your Google Sheets, then click on ‘Add-ons’ and select ‘Get Add-ons’. Search for ‘Pabbly Connect Webhooks’ and install it.

Once installed, navigate back to ‘Extensions’ and click on ‘Pabbly Connect Webhooks’ followed by ‘Initial Setup’. Here, you will paste the webhook URL you copied earlier. You will also need to specify the trigger column, which should be the last data column (e.g., Column G) in your spreadsheet.

• Open Google Sheets and click on Extensions.
• Select Add-ons, then Get Add-ons, and install Pabbly Webhooks.
• Go back to Extensions, click on Pabbly Connect Webhooks, and select Initial Setup.

After entering the webhook URL and trigger column, click on ‘Submit’. You should see a message confirming that the setup was successful, allowing you to test the connection.

4. Setting Up Action in Omnisend

Now that your trigger is set up, it’s time to configure the action in Omnisend. In Pabbly Connect, select Omnisend as the action application and choose ‘Create Subscriber’ as the action event. If you haven’t connected your Omnisend account yet, you will need to do so by providing your API key. using Pabbly Connect

To find your API key, log into your Omnisend account, go to your profile icon, and select ‘Store Settings’. Scroll down to the API key section, create a new key, and copy it back to Pabbly Connect. This will establish the connection between both applications.

• Select Omnisend as the action application in Pabbly Connect.
• Choose ‘Create Subscriber’ as the action event.
• Copy your API key from Omnisend and paste it into Pabbly Connect.

Once connected, you can map the fields from Google Sheets to the corresponding fields in Omnisend, such as email, first name, last name, city, and postal code. This mapping ensures that the subscriber information is accurately captured whenever a new row is added.

5. Testing the Integration

With everything set up, it’s time to test the integration between URL, City, and your subscriber creation process in Omnisend. To do this, add a new row in your Google Sheets with customer details, including first name, last name, email, phone number, city, state, and postal code.

After entering the new data, check your Omnisend account to confirm that the new subscriber has been created successfully. This step verifies that your automation is functioning correctly and that the data flows seamlessly from Google Sheets to Omnisend.

If the subscriber appears in Omnisend, congratulations! You have successfully integrated URL, City, Google Sheets, and Omnisend using Pabbly Connect. You can now enjoy automated subscriber management without manual data entry.

Conclusion

In this tutorial, we learned how to integrate URL, City, Google Sheets, and Omnisend for automated subscriber creation. This process streamlines your workflow and enhances efficiency in managing customer data.