Integrating Google Sheets with Omnisend Using Pabbly Connect

Learn how to integrate Google Sheets with Omnisend using Pabbly Connect to automate subscriber creation effortlessly. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Google Sheets and Omnisend Integration

To integrate Google Sheets and Omnisend, we first need to set up Pabbly Connect. Start by opening your browser and searching for Pabbly Connect. You can either sign in if you have an account or click on ‘Sign Up for Free’ if you don’t. This process is quick and grants you 100 free tasks every month.

Once logged in, you will be directed to the Pabbly Connect dashboard. Here, click on the ‘Create Workflow’ button to initiate a new project. Name your workflow something descriptive, such as ‘Create Omnisend Subscriber from New Google Sheets Row,’ and select the appropriate folder for organization.

2. Configuring the Trigger in Pabbly Connect Using Google Sheets

The next step involves configuring the trigger in Pabbly Connect. In your workflow, you will see two main sections: Trigger and Action. For the trigger application, search and select ‘Google Sheets.’ Next, choose the trigger event as ‘New or Updated Spreadsheet Row.’ This means that whenever a new row is added or updated in your Google Sheets, it will trigger the workflow.

• Select Google Sheets as the trigger application.
• Choose the trigger event: New or Updated Spreadsheet Row.
• Connect Google Sheets with Pabbly Connect using the provided webhook URL.

After selecting the trigger event, copy the webhook URL provided by Pabbly Connect. You will use this URL to connect your Google Sheets with Pabbly Connect. Go to your Google Sheets, navigate to ‘Extensions,’ and select the Pabbly Connect add-on to set it up.

3. Setting Up Google Sheets to Work with Pabbly Connect

Now, let’s set up Google Sheets to send data to Pabbly Connect. In your Google Sheets, ensure that you have a table with columns for first name, last name, email, phone number, and city. After ensuring the necessary columns are present, go to ‘Extensions’ and find the Pabbly Connect add-on. If it’s not installed, you can get it from the Google Workspace Marketplace.

Once installed, refresh your Google Sheets. Then, go back to the Pabbly Connect add-on and select ‘Initial Setup.’ Paste the webhook URL you copied earlier and specify the trigger column (e.g., column E). This column will be monitored for changes, and any new data entered will trigger the workflow.

• Open Extensions > Pabbly Connect > Initial Setup.
• Paste the webhook URL into the setup.
• Specify the trigger column (e.g., E for final data).

After completing the setup, send a test to ensure that Pabbly Connect receives the data correctly. Once the test is successful, click on ‘Submit’ to finalize the connection.

4. Creating the Action in Pabbly Connect to Add Subscribers to Omnisend

With the trigger configured, the next step is to create the action in Pabbly Connect. Search for and select ‘Omnisend’ as your action application. Choose the action event as ‘Create Subscriber.’ This action will take the data from your Google Sheets and create a new subscriber in Omnisend.

To connect Omnisend with Pabbly Connect, you will need to provide your API key. Log into your Omnisend account, navigate to your profile settings, and find the API keys section. Create a new API key and copy it back to Pabbly Connect.

Select Omnisend as the action application. Choose ‘Create Subscriber’ as the action event. Connect using your API key from Omnisend.

Once connected, map the fields from Google Sheets to the corresponding fields in Omnisend. This includes mapping the first name, last name, email, phone number, and city. After mapping, click on ‘Save and Send Test’ to ensure the subscriber is created successfully in Omnisend.

5. Finalizing the Integration and Testing the Workflow

After setting up both the trigger and action, it’s time to finalize the integration in Pabbly Connect. Ensure that all mappings are correct, and test the workflow by adding a new row in your Google Sheets. For instance, enter a new lead’s details such as first name, last name, email, phone number, and city.

Once you add this new row, Pabbly Connect will automatically trigger the workflow, sending the data to Omnisend to create a new subscriber. You can verify this by checking your Omnisend account under the audience section to see if the new subscriber has been added successfully.

With this setup, every time you add a new lead in Google Sheets, it will automatically create a new subscriber in Omnisend. This integration saves time and ensures your email list is always up-to-date.

Conclusion

By following this tutorial, you can easily integrate Google Sheets with Omnisend using Pabbly Connect. This automation allows you to create new subscribers effortlessly, ensuring your email marketing efforts remain efficient and effective.