In this blog, we are going to illustrate the step by step procedure to add Google Sheets rows from new Sendinblue campaign automatically using Pabbly Connect. This will automate the process to add Google Sheets rows from new Sendinblue campaign.
But before moving forward, let’s know a wee bit about both the software & why there is a need to integrate Sendinblue with Google Sheets. As we all know, Sendinblue is a SaaS solution for relationship marketing that offers a cloud-based marketing communication software suite with email marketing, SMS marketing, etc. On the other hand, Google Sheets is a spreadsheet program included as part of the free, web-based Google Docs office suite offered by Google within its Google Drive service.
By connecting Sendinblue with Google Sheets, one can automatically add rows in Google Sheets on every new contact addition in Sendinblue. To help you with this we are recommending the best automation and integration software named Pabbly Connect.
Why Choose This Method Of Integration?
In contrast with other integration services-
- Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer, and more
- Create “Unlimited Workflows” and smoothly define multiple tasks for each action
- As compared to other services which offer 750 tasks at $24.99, Pabbly Connect offers 50000 tasks in the starter plan of $29 itself
- Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
- Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE
Pabbly Connect is one of the best automation tools that allow you to integrate unlimited apps without any coding skills. Moreover, you can also access its features such as filters, path routers, etc even in its free plan.
Here in this blog, we will understand how to integrate Sendinblue with Google Sheets using Pabbly Connect. So, let’s start the integration process.
Step 1: Sign up to Pabbly Connect
Start the process to add Google Sheets rows from new Sendinblue campaign by visiting the website of Pabbly Connect and then click on the “Sign-Up Free” button. On the registration page, either signup using an existing Gmail account or manually fill out the form.
Try Pabbly Connect for FREE
Once you have completed the signup process, click on the Connect section in the dashboard to access Pabbly Connect. Start with creating a workflow for your project by clicking on the “Create Workflow” button. Now, you need to name the workflow just like in the above-shown image. I named the workflow as “Sendinblue to Google Sheets”, you can obviously name the workflow as per your requirements and needs. After naming your workflow, you have to select the application you want to integrate. Pabbly Connect allows you to integrate unlimited premium applications, try Pabbly Connect for free. Now, you have to select the application that you want to integrate. In this case, we are choosing “Sendinblue” for integration. After selecting the application select “New Contact Added to a List” in the choose method section. After selecting the application, now you have to copy the webhook URL just like in the above-shown image to take further the integration process. To connect Sendinblue with Pabbly Connect, you have to paste the copied webhook URL in the software, for that, you need to log in to your Sendinblue account. Once you log into your Sendinblue account, go to the “Settings” section on the left of the dashboard. After reaching the settings page, now click on the “Configure” button of the webhooks option. Next, click on the “Add a New Webhook” button to paste the webhook URL. Now, paste the webhook URL and select the “Added to a List” option, and then hit the “Add” button. To check if the integration is capturing data or not, we will add a sample contact to the Sendinblue account. Now to add a contact, click on the “Contacts” option in your Sendinblue dashboard. After selecting contacts, click on the “Add a Contact” button. Add all the details of the contact like name, email, address, etc. After filling up all the required details, hit the “Save and Close” button. But before that, click on the “Capture Webhook Response” button in the Pabbly Connect dashboard. As soon as you click on the “Save and Close” in Sendinblue and “Capture Webhook Response” in Pabbly Connect the entry will appear on the Pabbly Connect dashboard. Then, click on the “Save” option. To make this Sendinblue-Google Sheets integration work, you have to choose the action for your trigger. Now in this step, click on the + button below and choose the application that you want to integrate. Here we will choose “Google Sheets” to integrate and in the method section select “Add New Row”. After choosing the application click on the “Connect with Google Sheets” button to move forward. To connect Google Sheets with Pabbly Connect, you have to select your Google Account to authorize the application. After clicking on the button, a pop-up window will appear where you have to click on the “Connect with Google Sheets” button to authorize your Google account. Select your account for data transmission. After connecting with your Google account, map all the fields quickly like list ID, name, etc. Once you are done adding up all field data click on the “Save & Send Test Request” button. Here, you can see that our integration was successful and the Sendinblue contact info has been saved in your Google Sheet automatically. Now, whenever there will be any new contact in your Sendinblue account, they will be automatically saved in your Google Sheets. Finally, now you know how to add Google Sheets rows from new Sendinblue campaign. This is a one-time process, now all your manual work will be done by the online business automation and integration tool i.e Pabbly Connect. Just follow this step by step procedure mentioned above and your Sendinblue to Google Sheets integration is all set. So, what’s stopping you now! Go and catch your deal by signing up for a free account. In case of any queries, please drop your comments below. We will try to reach you as soon as possible.Step 2: Access Pabbly Connect
Step 3 : Workflow for Sendinblue with Google Sheets Integrations
(a) Create New Workflow
(b) Name the Workflow
Step 4 : Setting Triggers for Sendinblue with Google Sheets Integrations
(a) Select Application you want to Integrate
(b) Copy the Webhook URL
Step 5 : Connecting Sendinblue to Pabbly Connect
(a) Go to Sendinblue Settings
(b) Click on Webhooks
(c) Click Add New Webhooks
(d) Paste the Webhook URL
Step 6 : Add a Contact
(a) Click on Contacts
(b) Click on Add a Contact
(c) Add Contact
Step 7 : Test the Submission in Pabbly Connect Dashboard
Step 8 : Setting Action for Sendinblue with Google Sheets Integrations
(a) Select Application you Want to Integrate
(b) Click the Connect Button
Step 9: Connecting Google Sheets to Pabbly Connect
(a) Authorize the Application
(b) Map the Fields
(c) Save and Send Test Request
Step 10: Check Response in Google Sheets
Conclusion –
You May Also Like to Read –