How to Create Docs from Google Forms Responses and Share on Slack Using Pabbly Connect

Learn how to automate document creation from Google Forms responses and share them on Slack using Pabbly Connect. This step-by-step tutorial covers all necessary integrations.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Google Forms and Slack Integration

To start automating document creation from Google Forms responses, first, access Pabbly Connect. Sign in to your account or create a new one for free, which allows you to utilize 100 tasks monthly at no cost.

Once logged in, navigate to the dashboard. Click on the button labeled ‘Create Workflow’ to initiate the process. You will be prompted to name your workflow, so enter something like ‘Create Docs for Google Forms Responses and Share on Slack’ and select a folder to save it in.

2. Setting Up the Trigger in Pabbly Connect with Google Forms

The next step involves setting up the trigger for your workflow in Pabbly Connect. For this integration, select Google Forms as your trigger application. Choose the event ‘New Response Received’ to capture responses from your Google Forms.

• Select Google Forms as the trigger application.
• Choose ‘New Response Received’ as the trigger event.
• Copy the provided webhook URL for further setup.

After copying the webhook URL, link it to your Google Form by opening the form, navigating to the Responses tab, and clicking on ‘Link to Sheets’. Create a new spreadsheet to ensure responses are recorded there, which will enable Pabbly Connect to capture them automatically.

3. Generating Content with Google Gemini via Pabbly Connect

With the trigger set, it’s time to add an action step using Pabbly Connect. Select Google Gemini as your action application, and choose ‘Generate Content’ as the action event. This will allow you to create a summary of the feedback received through the Google Form.

To establish a connection, you’ll need to provide an API key from Google AI Studio. After obtaining the key, input it into Pabbly Connect. Next, map the relevant fields from the previous step, such as customer feedback and ratings, to generate a concise conclusion.

• Select Google Gemini as the action application.
• Choose ‘Generate Content’ as the action event.
• Map data from the Google Form to create a dynamic summary.

Once you have configured these settings, test the action to ensure that the content is generated correctly. This will provide a summary based on the feedback received from your customers.

4. Creating Documents in Google Docs Using Pabbly Connect

After generating the content summary, the next step is to create a document in Google Docs. In this step, select Google Docs as your action application in Pabbly Connect and choose ‘Create Document from Template’ as the action event.

Before proceeding, ensure you have a document template ready in Google Docs. Choose the template you wish to use and map the fields from the previous steps, such as customer name, feedback, and the generated conclusion, into the template placeholders.

Select Google Docs as the action application. Choose ‘Create Document from Template’ as the action event. Map customer feedback and generated content into the template.

Once the document is created, you will receive a document ID, confirming successful creation. This document will store all relevant information gathered from the Google Form responses.

5. Sharing Documents on Slack Using Pabbly Connect

The final step is to share the newly created document on Slack. In Pabbly Connect, add another action step and select Google Drive as your application, then choose ‘Share File with Anyone’ as the action event. This step ensures that the document is accessible to your team.

Map the document ID from the previous step to allow sharing. After setting this up, you can add another action step to send a message on Slack. Choose Slack as your action application and select ‘Send Channel Message’ as the action event. This will notify your team about the new document.

Select Google Drive as the action application. Choose ‘Share File with Anyone’ as the action event. Select Slack to send a message about the document.

Once you have configured these actions, test the entire workflow to ensure that the document is shared successfully on Slack, allowing your team to access customer feedback efficiently.

Conclusion

In this tutorial, we demonstrated how to create documents from Google Forms responses and share them on Slack using Pabbly Connect. This seamless integration allows businesses to automate their feedback process, ensuring timely communication and documentation of customer insights.