How to Add New Contacts in iContact from Google Sheets Using Pabbly Connect

Learn how to automate adding contacts from Google Sheets to iContact using Pabbly Connect in this step-by-step tutorial. 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. Setting Up Pabbly Connect for Integration

To begin adding contacts in iContact from Google Sheets, you first need to set up Pabbly Connect. This platform enables seamless automation between various applications, including Google Sheets and iContact. Start by signing up for a free account on the Pabbly Connect website.

Once you have created your account, log in to access the dashboard. Click on the ‘Create Workflow’ button. Name your workflow, for example, ‘Google Sheets to iContact’, and click on the ‘Create’ button to proceed. This will set the stage for the automation process.

2. Configuring the Trigger Event in Pabbly Connect

In this section, you’ll configure the trigger event that starts the workflow. The trigger application will be Google Sheets, and the trigger event will be ‘New or Updated Row’. Select Google Sheets from the list of applications in Pabbly Connect.

• Search for and select Google Sheets as the trigger application.
• Choose ‘New or Updated Row’ as the trigger event.
• Copy the generated webhook URL provided by Pabbly Connect.

Now, open your Google Sheets document where you have your contact details stored. If you’re using multiple Google accounts, open the spreadsheet in an incognito window. After that, you need to install the Pabbly Connect Webhooks add-on from the Google Workspace Marketplace.

3. Connecting Google Sheets to Pabbly Connect

After installing the Pabbly Connect Webhooks add-on, you need to set it up to connect with Pabbly Connect. In your Google Sheets, go to the ‘Extensions’ menu, find the Pabbly Connect Webhooks option, and click on ‘Initial Setup’.

• Paste the webhook URL you copied from Pabbly Connect into the designated field.
• Specify the trigger column, which is the last column where data will be entered (e.g., column E).
• Click on the ‘Send Test’ button to ensure the connection works properly.

Once you have set up the initial configuration, you should see a confirmation message indicating that the test data has been sent successfully to Pabbly Connect. This confirms that your Google Sheets is now connected to Pabbly Connect.

4. Setting Up the Action Event in Pabbly Connect

Now that Google Sheets is connected to Pabbly Connect, it’s time to set up the action event. This action will be to create a contact in the iContact application. Search for iContact in the action step section of Pabbly Connect.

Select ‘Create Contact’ as the action event. You will need to establish a connection to iContact by entering your application ID, API password, username, and API URL. These credentials can be found in your iContact account settings under the integrations section.

5. Testing and Finalizing the Integration

After configuring the action event, it’s crucial to test the integration. Click on the ‘Save and Send Test Request’ button in Pabbly Connect. This action will create a new contact in iContact using the data you mapped from Google Sheets.

Once the contact is successfully created, you can verify by logging into your iContact account. Refresh the contacts page to see if the new contact appears. If everything is set up correctly, any new entries added to Google Sheets will now automatically create contacts in iContact through Pabbly Connect.

Conclusion

In this tutorial, we have demonstrated how to automate adding new contacts from Google Sheets to iContact using Pabbly Connect. This integration simplifies your workflow, allowing for efficient contact management with minimal manual effort. By following these steps, you can easily set up a seamless connection between these applications.