Integrating Delighted Survey Responses to Google Sheets with Pabbly Connect

Learn how to automate adding Delighted survey responses to Google Sheets using Pabbly Connect with this step-by-step tutorial. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Delighted Survey Responses

To integrate Delighted survey responses into Google Sheets, we first need to set up Pabbly Connect. This automation platform allows us to create workflows that connect different applications seamlessly. Start by signing up for a free account on Pabbly Connect’s dashboard.

Once logged in, click on ‘Create Workflow’ and name it something descriptive, like ‘Delighted to Google Sheets’. This will help you easily identify the workflow later on. After naming it, click on ‘Create’ to open your workflow.

2. Trigger Setup: Connecting Delighted to Pabbly Connect

The next step is to set up the trigger in Pabbly Connect. In the trigger window, search for and select ‘Delighted’. Choose the trigger event ‘New Survey Response’. This event will trigger the automation whenever someone responds to your survey.

Pabbly Connect will provide you with a webhook URL. Copy this URL and head over to your Delighted account. Go to the Integrations page, click on ‘Set Up’ under Webhook, and add a new rule. In the notification settings, select to send all responses to the copied webhook URL.

• Copy the webhook URL from Pabbly Connect.
• In Delighted, set up a new webhook rule to send responses to this URL.
• Test the connection to ensure data is received.

After setting this up, click on ‘Send Test’ in Delighted to confirm if the data is reaching Pabbly Connect. Once you see the test response in the workflow, save and turn on the connection.

3. Action Setup: Sending Data to Google Sheets

Now that we’ve set up the trigger, we need to configure the action to send data to Google Sheets using Pabbly Connect. Scroll down to the action window, search for ‘Google Sheets’, and select the action event ‘Add New Row’.

Next, connect your Google Sheets account with Pabbly Connect. Click on ‘Connect with Google Sheets’, select your account, and grant the necessary permissions. Once connected, choose the spreadsheet where you want to add the survey responses.

• Select the spreadsheet named ‘Survey Responses’.
• Ensure the spreadsheet has columns for name, email, score, comment, and timestamp.
• Map the fields from Delighted responses to the corresponding columns in Google Sheets.

After mapping the fields correctly, save your changes. This setup will ensure that every new response from Delighted is automatically added as a new row in your Google Sheets.

4. Formatting Date and Time Before Adding to Sheets

To ensure the timestamp from Delighted is in a readable format, we need to format the date and time using Pabbly Connect. Before the Google Sheets action, add a new action step and select ‘Date Time Formatter’. Choose ‘Format Date with Time Zone’ as the action event.

Map the timestamp from the Delighted response to the date field in the Date Time Formatter. Specify the current format as ‘Timestamp’ and choose your desired output format. Set the time zone to Asia/Kolkata to align with your local time.

Select the timestamp from Delighted responses. Choose the output format for date and time. Set the time zone to Asia/Kolkata.

After configuring this step, test it to ensure the date and time are formatted correctly. This will help keep your Google Sheets organized and easy to read.

5. Finalizing the Integration and Testing

With everything set up, it’s time to finalize the integration in Pabbly Connect. Ensure all fields are mapped correctly, especially the formatted date and time. Click on ‘Save and Test Request’ to confirm the entire workflow is functioning as expected.

Check your Google Sheets to verify that the new row with the survey response has been added successfully. You should see the name, email, score, comment, and the formatted date and time in the respective columns.

This integration allows you to automate the process of adding Delighted survey responses to Google Sheets seamlessly. With Pabbly Connect, you can easily manage your survey data without manual intervention.

Conclusion

By following this guide, you have successfully set up an automation workflow using Pabbly Connect to add Delighted survey responses to Google Sheets. This integration streamlines data management, making it easier to analyze feedback effectively.