How to Write Text Summary Using Writesonic with Pabbly Connect

Learn how to automate text summarization using Writesonic and Pabbly Connect when a new form response is received in Google Sheets. Step-by-step guide included. 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. Accessing Pabbly Connect for Automation

To start automating text summarization using Pabbly Connect, first, you need to sign up for an account. Visit the Pabbly Connect website and create an account to access its features. This platform allows seamless integration between various applications, including Google Sheets and Writesonic.

After signing up, log into your Pabbly Connect account. You will be directed to the dashboard, where you can create a new workflow. Click on the ‘Create Workflow’ button and name your workflow something relevant, such as ‘Google Sheets to Writesonic’. This naming helps in identifying the automation later.

2. Setting Up Google Forms Trigger in Pabbly Connect

In this step, you will set up the trigger for your workflow. Select Google Forms as the trigger application in Pabbly Connect. The trigger event you need to choose is ‘New Response Received’. This ensures that every time a new form response is submitted, the workflow will be activated.

• Select Google Forms as the trigger application.
• Choose ‘New Response Received’ as the trigger event.
• Copy the Webhook URL provided by Pabbly Connect.

After copying the Webhook URL, you need to integrate it into your Google Forms. Open your connected Google Sheet in an incognito window to avoid account conflicts. Click on Extensions, then Add-ons, and choose ‘Get Add-ons’ to install the Pabbly Connect Webhooks add-on. After installation, refresh your spreadsheet.

3. Configuring Pabbly Connect Webhooks

Once you’ve installed the Pabbly Connect Webhooks add-on, go back to Extensions, and click on Pabbly Connect Webhooks, then select ‘Initial Setup’. Here, paste the Webhook URL you copied earlier into the appropriate field. Additionally, specify the trigger column, which is typically the final data column in your Google Sheet. using Pabbly Connect

After setting this up, click on ‘Send Test’ to send test data from your spreadsheet to Pabbly Connect. This step is crucial as it confirms that the integration is working correctly. You should see a message indicating that the test data was sent successfully.

• Paste the Webhook URL in the designated field.
• Select the trigger column where the data is entered.
• Click ‘Send Test’ to verify the setup.

Once the test is successful, you can finalize the setup by enabling the ‘Send on Event’ option, which ensures that every new form submission will trigger the workflow.

4. Summarizing Data with Writesonic

Now that your trigger is set up in Pabbly Connect, the next step is to summarize the data using Writesonic. Add a new action step in your workflow and choose Writesonic as the application. Select the action event as ‘Text Summary’ to enable the summarization feature.

You will need to connect your Writesonic account to Pabbly Connect by entering your Writesonic API key. To find this key, log into your Writesonic account, navigate to your profile, and access the API dashboard. Ensure that the API status is active before copying the key.

Select Writesonic as the action application. Choose ‘Text Summary’ as the action event. Enter your Writesonic API key to connect.

After connecting, map the text you want to summarize from the Google Sheets data into the appropriate field. You can then test this action to see the summarized output generated by Writesonic.

5. Updating Google Sheets with the Summary

The final step is to update your Google Sheet with the summarized text generated by Writesonic. Add another action step in Pabbly Connect and select Google Sheets again. This time, choose the action event as ‘Update Cell Value’ to reflect the summary back into your spreadsheet.

Connect to your Google Sheets account again and specify the sheet you want to update. You will need to enter the range of the cell where you want the summary to appear. Use the row index from the previous steps to ensure that the summary is placed correctly in the corresponding row.

Select Google Sheets for the action step. Choose ‘Update Cell Value’ as the action event. Specify the cell range for the summary output.

Once you save and test this step, your Google Sheet will be updated with the summarized text every time a new form response is received. This setup allows for seamless automation of text summarization using Pabbly Connect.

Conclusion

In this tutorial, we demonstrated how to automate the process of summarizing text using Writesonic and Pabbly Connect whenever a new form response is received in Google Sheets. By following these steps, you can efficiently create summaries without manual intervention, enhancing your productivity significantly.