How to Add BombBomb Contacts from Google Sheets Using Pabbly Connect

Learn how to integrate Google Sheets with BombBomb to add contacts automatically using Pabbly Connect. Follow our step-by-step tutorial for seamless automation. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Google Sheets and BombBomb Integration

To begin adding BombBomb contacts from Google Sheets, first, access Pabbly Connect. Type the URL Pabbly.com/connect in your browser. This will take you to the landing page of Pabbly Connect.

On the right-hand side, you will see options to sign in or sign up for free. If you are a new user, click on ‘Sign Up’ to create your account. You will receive 100 free tasks upon account creation. Once signed up, click on ‘Sign In’ to access your dashboard.

2. Create a Workflow in Pabbly Connect

Once logged into Pabbly Connect, click on the ‘Create Workflow’ button on the dashboard. A dialog box will prompt you to name your workflow. Here, you can name it something like ‘Add BombBomb Contacts from Google Sheets’.

After naming your workflow, click on ‘Create’. You will be directed to a new window with two significant events: Trigger and Action. For this integration, your trigger application will be Google Sheets, and the action application will be BombBomb.

3. Set Up Google Sheets as the Trigger Application

In the new window, select Google Sheets as your trigger application. The trigger event will be ‘New or Updated Spreadsheet Row’. Upon selecting this, you will receive a webhook URL. This URL acts as a bridge between Pabbly Connect and Google Sheets.

Copy the webhook URL and navigate to your Google Sheets. Open the spreadsheet you want to use, and make sure it contains the necessary columns: First Name, Last Name, Email Address, and Phone Number. To set up the integration, go to Extensions > Add-ons > Get Add-ons in Google Sheets.

• Search for Pabbly Connect Webhooks.
• Install the add-on if it’s not already installed.
• Close the add-on window and refresh your Google Sheets.

Once refreshed, go back to Extensions > Pabbly Connect Webhooks and select ‘Initial Setup’. Paste the copied webhook URL into the designated field and set the trigger column to the final data column. For example, if your final column is D, input D here. Then click on ‘Send Test’ to ensure the setup works successfully.

4. Set Up BombBomb as the Action Application

Now that your trigger is set up, return to Pabbly Connect to add the action application. Select BombBomb and the action event will be ‘Create a Contact’. Click on ‘Connect’ to establish a connection between Pabbly Connect and your BombBomb account.

You will be prompted to authorize the connection. Click ‘Allow’ to grant Pabbly Connect access to your BombBomb account. After successful authorization, proceed to map the fields from your Google Sheets to BombBomb.

• Map First Name from Google Sheets to BombBomb.
• Map Last Name from Google Sheets to BombBomb.
• Map Email Address and Phone Number similarly.

Once all fields are mapped correctly, click on ‘Save and Send Test’. You should see a confirmation that the contact has been created successfully in BombBomb.

5. Verify the Integration and Test It

To verify that your integration is functioning as intended, go back to your BombBomb account and check the contacts list. You should see the newly created contact based on the information you added to Google Sheets. This confirms that Pabbly Connect successfully facilitated the integration.

To further test, add a new contact in Google Sheets with details like First Name: Testing123, Last Name: NewOne, Email Address: [email protected], and Phone Number: 1234567890. Refresh your BombBomb contacts page to check if this new entry appears.

If the new contact appears in BombBomb, your integration setup is complete and functioning smoothly. This demonstrates how Pabbly Connect can automate the process of adding contacts from Google Sheets to BombBomb effortlessly.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate adding BombBomb contacts from Google Sheets. By following the steps outlined, you can streamline your workflow and enhance productivity through seamless integration.