How to Create Contacts on Sensorpro from Google Sheets Using Pabbly Connect

Learn how to use Pabbly Connect to create contacts in Sensorpro directly from Google Sheets in this detailed tutorial. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect to Set Up Automation

To create contacts in Sensorpro from Google Sheets, you first need to access Pabbly Connect. This platform allows you to automate the integration between Google Sheets and Sensorpro seamlessly.

Start by signing up for a free account on the Pabbly Connect website. Once logged in, you will be directed to the dashboard where you can create your first automation workflow.

2. Create a Workflow in Pabbly Connect

In this step, you will create a workflow in Pabbly Connect that connects Google Sheets to Sensorpro. Click on the ‘Create Workflow’ button and name your workflow appropriately, such as ‘Google Sheets to Sensorpro’.

After naming the workflow, you will see two modules: Trigger and Action. The Trigger module will be set to Google Sheets, which will initiate the workflow when new data is added. The Action module will be set to Sensorpro to create a contact automatically based on the data from Google Sheets.

3. Set Google Sheets as Trigger Application

To set up the trigger, select Google Sheets as the application in Pabbly Connect. Choose the trigger event as ‘New or Updated Row’. This will allow the workflow to activate whenever a new row is added or an existing row is updated in your Google Sheets.

Upon selecting the trigger event, a webhook URL will be generated. You need to copy this URL and follow the provided steps to connect it to your Google Sheets. Ensure to open your Google Sheets in an incognito window if you are using multiple Google accounts.

• Copy the webhook URL from Pabbly Connect.
• Open Google Sheets in an incognito window.
• Paste the webhook URL in the appropriate add-on settings.

After completing these steps, send a test request to capture the response in Pabbly Connect to ensure everything is working correctly.

4. Set Sensorpro as Action Application

Next, you will set Sensorpro as the action application in Pabbly Connect. Search for Sensorpro and select the action event ‘Create Contact’. This action will use the data received from Google Sheets to create a new contact in Sensorpro.

To connect to Sensorpro, you will need to provide your organization name, user ID, password, and API key. The API key can be found in the settings section of your Sensorpro account. Once you enter these details, click on the ‘Save’ button to establish the connection.

5. Map Data and Send Requests

After successfully connecting to Sensorpro, you will need to map the data fields from Google Sheets to Sensorpro. This includes the first name, last name, and email address. If the full name is provided in one field, you can use the text formatter in Pabbly Connect to split it into first and last names.

Once the data is mapped correctly, test the connection by sending a test request. If successful, a new contact will be created in Sensorpro. You can verify this by checking the contacts section in your Sensorpro account. If you wish to add multiple contacts at once, use the ‘Send All Data’ option from the Pabbly Connect add-on.

This automation setup means that every time you add a new row in Google Sheets, a contact will be created automatically in Sensorpro without any manual intervention.

Conclusion

Using Pabbly Connect, you can effortlessly create contacts in Sensorpro from Google Sheets. This integration streamlines your workflow, saving time and reducing manual data entry. Follow the steps outlined in this tutorial to set up your automation today.