Integrate Google Sheets with Vbout Using Pabbly Connect: A Step-by-Step Guide

Learn how to integrate Google Sheets with Vbout using Pabbly Connect. This step-by-step guide covers all the necessary actions and settings for seamless automation. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start the integration process, access Pabbly Connect by visiting the official website. If you’re a new user, click on ‘Sign Up for Free’ to create an account. Existing users should click on ‘Sign In’ to enter their dashboard.

Once logged in, navigate to the Pabbly Connect application. Click on ‘Access Now’ to proceed. From your dashboard, select the option to create a new workflow, which will initiate the integration process.

2. Creating a Workflow in Pabbly Connect

In this step, you will create a workflow to connect Google Sheets and Vbout. Click on the ‘Create Workflow’ button. You will be prompted to name your workflow; for example, name it ‘Create Vbout Contact from Google Sheets Row’ and select the appropriate folder to save it.

• Click on ‘Create’ to open the workflow window.
• This window contains the trigger and action settings for your automation.

In the workflow window, select Google Sheets as the trigger application. For the trigger event, choose ‘New or Updated Spreadsheet Row’. This action will ensure that every time a new lead is added to Google Sheets, it will trigger the workflow in Pabbly Connect.

3. Setting Up Google Sheets Integration

After selecting Google Sheets as your trigger application, Pabbly Connect will provide a Webhook URL. Copy this URL, as it will be used to connect Google Sheets with your workflow.

• Open your Google Sheets document where you want to track new leads.
• Go to Extensions > Add-ons > Get Add-ons and search for ‘Pabbly Connect Webhooks’.

Install the add-on, then refresh your Google Sheets. Once refreshed, navigate back to Extensions, select Pabbly Connect Webhooks, and proceed to the initial setup. Here, paste the copied Webhook URL and set the trigger column, which should be the final data column.

4. Testing the Integration with Pabbly Connect

Now that the Google Sheets integration is set up, it’s time to test the connection. Go back to your Google Sheets and fill in a new lead’s details. Ensure that the final data column is filled out to trigger the workflow.

Navigate to Extensions > Pabbly Connect Webhooks. Switch on the ‘Send on Event’ button to enable automatic data sending.

After entering the lead details, check Pabbly Connect to see if the test submission was captured successfully. You should see the details of the new lead reflected in your workflow.

5. Creating a Vbout Contact through Pabbly Connect

With the trigger successfully set, the next step is to add an action step to create a new contact in Vbout. Select Vbout as the action application and choose ‘Add Contact to List’ as the action event. using Pabbly Connect

Connect your Vbout account using the API user key from your Vbout settings. Map the required fields from the trigger data, such as email, first name, and last name.

Once all fields are mapped, click on ‘Save and Send Test Request’. You should receive a confirmation that the contact was created successfully in your Vbout account. This integration ensures that every new lead from Google Sheets is automatically added to your Vbout contact list, streamlining your marketing efforts.

Conclusion

This tutorial demonstrated how to integrate Google Sheets with Vbout using Pabbly Connect. By following these steps, you can automate the process of adding new leads to your Vbout account, enhancing your marketing efficiency.