This post will explore the process of linking Google Forms and Google Tasks. Once integrated, every time a response is submitted through your Google Forms, a corresponding task will be generated in your Google Tasks automatically.
This automation requires a one-time setup, for which we will use Pabbly Connect.
Initially, we will connect Google Forms with Pabbly Connect to obtain new form submissions, and subsequently, we will connect Pabbly Connect with Google Tasks to generate tasks based on the received responses.
Steps to Automatically Create Google Tasks from Google Forms Responses
1. Sign In / Sign Up to Pabbly Connect and Create a Workflow
2. Setup Google Forms as the Trigger App to Gather Responses
3. Add Date / Time Formatter to the Workflow
4. Setup Google Tasks as the Action App to Create Tasks
Step 1:- Sign In / Sign Up to Pabbly Connect and Create a Workflow
A. Sign In / Sign Up
To begin this process, visit Pabbly Connect and create your account by clicking on the ‘Sign Up Free’ button. You can also click on Sign In if you already have an account.
Click on the Pabbly Connect ‘Access Now’ button
B. Create Workflow
To create a new workflow, click the ‘Create Workflow’ button.
Name your workflow, and click on ‘Create’.
Step 2:- Setup Google Forms as the Trigger App to Gather Responses
We will now outline the process of connecting Google Forms with Pabbly Connect, which will enable us to retrieve responses from Google Forms.
A. Trigger App
Trigger enables us to select the application from which Pabbly Connect will retrieve the data. In this instance, it would be Google Forms.
Choose ‘Google Forms’ as the Trigger App and select ‘New Response Received’ as a Trigger Event.
B. Webhook URL
You will be given a new Webhook URL which can be used to connect your Google Forms account. Copy the Webhook URL.
Once you have copied the Webhook URL, Pabbly Connect will immediately begin searching for Google Forms responses, which is indicated by the rotating Waiting For Webhook Response button.
C. Connect Google Forms Account
To establish a connection with your Google Forms account, navigate to the specific form whose response you wish to capture and submit a dummy response.
Then click on the 3 dots and ‘Select response destination’.
Select ‘Create a new spreadsheet’ and click on ‘Create’.
Click the green ‘View in Sheets’ icon, which will redirect you to a new spreadsheet where your response and all other Google Forms responses will be recorded. This sheet will serve as a repository for Pabbly Connect to capture the data.
Click on Extensions > Add-ons > Get add-ons, and search for ‘Pabbly Connect Webhook’.
Install the Pabbly Connect Webhook extension.
After installing the add-on, again click on Extension > Pabbly Connect Webhooks > Initial Setup.
Paste the previously copied Webhook URL into its designated field. In the Trigger Column, specify the name of the last column where the data can be found. Afterward, click on the ‘Send Test’ button.
Once the data has been sent successfully, you may proceed to click on the ‘Submit’ button.
At last, click on Extension > Pabbly Connect Webhooks > ‘Send On Event’ – This will ensure that your Google Forms responses will automatically be captured by Pabbly Connect.
Switch back to Pabbly Connect, expand Response Received, where the respondent details must be visible, thus confirming our established connection.
Step 3:- Add Date / Time Formatter to the Workflow
Google Tasks requires us to enter the due date along with the timezone, but the response we obtained from Google Forms does not have that – to address this issue, we will add a Date/Time Formatter to our workflow.
Choose ‘Date/Time Formatter by Pabbly’ as the Action App, select ‘Format Date with Time Zone’ as an Action Event, and click on ‘Connect’.
Map the Due Date from the step above.
Choose the ‘From’ and ‘To’ formats.
Select From and To Timezone, and click on ‘Save & Send Test Request’.
The Due Date has now been converted to the correct format.
Step 4:- Setup Google Tasks as the Action App to Create Tasks
Action allows us to choose the application that will get executed by the workflow trigger.
We essentially want to use the captured responses to create new tasks in Google Tasks. Therefore, Google Tasks will be our designated Action App.
B. Connect Google Tasks Account
To connect with your Google Tasks account, select ‘Add New Connection’ and click on ‘Sign in with Google’. Also, grant the necessary authorization.
C. Map Necessary Fields
Now that you have connected your Google Tasks account, all you need is to map the responses from the previous step. Mapping ensures our data remains dynamic and changes as per the received responses.
Enable the mapping button, and map the Task List from the trigger step.
Similarly, map the other fields, and click on ‘Save & Send Test Request’.
As soon as you click on Save & Send Test Request, a new task will be added to your Google Calendar task list.
Our automation process is finished, and we have successfully merged Google Forms and Google Tasks. From now on, every time a user responds to your Google Forms, a corresponding task will be automatically created in your Google Tasks account.
You can copy this entire workflow by clicking this link.
Sign Up for a free Pabbly Connect account, and start automating your business
Subscribe to our Youtube Channel for more such automation
For any other queries, visit our forum