Add-ons
Check out the store for many more
Add-on

Google Forms to Asana Checklist Pro


(9)
3,004 users

Overview

Submit Google Forms to Asana as a task or project. Auto create Task Checklists, resubmit forms, send email notifications and more!
Google Forms to Asana Integration.  A simple and elegant way to systemise all of the tasks in your business from Google Forms into Asana!

VERSION 3 is OUT NOW!

See this page for full details and pricing
https://c2solutions.com.au/google-forms-asana-checklist-pro/

- Are you wanting to submit Google forms into Asana and create a task?
- Do you want to replicate a complete Task Template into Asana
when you submit a Google Form?
- Want to send email notifications when you submit a Google Form?
- Maybe you want to re-submit your Google form and have Asana updated?

Then you found the right solution!

OVERVIEW
Every business has many repeating steps that they perform on a regular basis. With this tool all of those steps can be automated into Asana when a Google Form is submitted.  Those steps usually kick off when a key trigger initiates the process. That trigger could be an internal person starting a project or requesting something to be done, a client requesting you do something, or the initiation of a new lead for the business.  The possibilities are endless and there are lots of repeating tasks in your business that this solution can help simplify.

Google Forms to Asana Checklist Pro comes packed with a bunch of features that allow communication between Google forms and Asana for automating and systemising these everyday tasks in your business.


FEATURES OF GOOGLE FORMS TO ASANA CHECKLIST PRO:
We have built a lot of features into this product and that makes it simple to use but powerful in what it can deliver for you:
- Submit Google forms into Asana
- Manage all your business task checklists (for Asana) from a central Dashboard for all of your Google forms
- Create either a parent task or project in Asana for each Google form submission
- Send an email notifications on Google form submission to multiple recipients
- Store all the Google form details in the Asana task or project
- Store all the Google form details in email notification
- Create your own checklists of tasks for each Google Form (an Asana task template)
- Task checklists are automatically created as tasks (or subtasks) on form submission
- A unique editable URL is provided in the Asana task and email so you can edit the original Google form submission and re-submit changes.
- Google Form submission version tracking
- Full revision history of Google form re-submissions
- Update Asana parent task or project on Google form re-submission
- Set notes against each sub-task that is created
- Set parent task owner and "due in X days" on the parent task
- Create a custom email/task subject based on fields in your form
- Set assignees, plus multiple followers and tags on sub-tasks
- Create a custom email/task subject based on fields in your form
- Create cascading due dates for tasks based on the Google form submission (not currently possible in Asana)
... and many more!


WHAT YOU CAN USE IT FOR:
Keep in mind, the Google form that starts the process can be used both internally by your staff and externally by your clients.  This solution gives you LOTS of options:

- Capture leads in your business and track them in Asana
- Initiate a project and create all the tasks that need to be done automatically
- Kick off a hire or sale and gather the client information upfront
- Collect support requests from clients
- Fire off a checklist that you need someone to do
- Report a bug to your teammate
- Collect employee data from your team
- Create a list of tasks your Virtual Assistant has to do regularly
- Gather feedback from clients and take action on it
- Capture your client preferences at the start of a project


FAQ?
Q: Does this work on the free version of Asana?
A: Yes.

Q: Can I use form created in my personal Gmail account
A: Yes.  You can use it with any Google Form, created in either your personal Gmail account or Google G Suite accounts.

Q: Does this support Google Forms "file upload" feature?
A: Yes. We've made a lot of effort to ensure that the file upload feature results in a URL link in the notifications email and Asana task that links to the uploaded file.

Q: Does this solution support Google Forms "section" feature?
A: Yes 🙂 Sections work great with the solution. We support all the Google Form functionality.

Q: Can I use this for my whole business? Can my team use it?
A: Yes, One license allows anyone in your Google G Suite Account (your domain) to create forms for submission into Asana.

Q: Can I have more than one dashboard for my task checklists?
A: Yes, You can create a separate dashboard for each form if you like or one dashboard for all the tasks across all of your Google forms.  Keep in mind, that if you use a dashboard and have multiple users they will need access to edit the dashboard to make changes and connect their own forms.

Q: Does the trial require me to enter my credit card details?
A: No, the trial is completely free and only requires you to sign up for to get a trial license to activate the product. The license will be emailed out to you. Only once the trial ends will you buy the Pro version license.

Q: I have an issue with my license or want help what do I do?
A: You can contact us here for support.

Q: Does Google Forms to Asana Checklist Pro work with Team Drive?
A: No, Team Drive is a recently-released feature and is not currently supported. Move your form outside of the Team Drive into the normal Google Drive. We'll be working on fixing this to include support for Team Drive in upcoming releases. 

Q: When I install the add-on it requests authorisation to google drive etc.  Why?
A: Google Forms to Asana Checklist Pro has to link Google spreadsheets and forms together to create the solution. Naturally these sit in your Google Drive and through our setup Wizard we prompt users to create these documents.  But we need permission to be able to move them into the same folder as your originating Google form. Is just for simplicity so you can find the linked files that were created in the same folder as your form. 🙂
Also Google forms released a new feature several months ago that allows an end user to upload files through the Google form as one of the questions in the form.  Its pretty cool actually!  So to make our product compatible we had to ensure that if someone used this feature and requested a form submitter to upload a file that our your Asana tasks and emails would generate the Google Drive link properly for the uploaded file, so that if you click it, the file opens.

Google Forms to Asana Checklist Pro
VERSION HISTORY

v3.1.4.2 28/02/2018
Fix Bug on Re-submission of Parent task when Parent Task Owner Due Date is not defined
Removed debugger from SettingsUI

v3.1.4 30/9/2017
Add function to cleanup the use of triggers to ensure only one trigger per form
Added version number to sidebar bottom and into loader

v3.1.3 29/9/2017
Update to Setup Wizard to ensure only one trigger created per form
Update to date function and month being 1 month out

v3.1.2 29/9/2017
Update to Setup Wizard main to capture triggers

v3.1.1 28/9/2017
Added error catching to setup wizard main processing
Added timezone dropdown into Settings to allow for users to select their timezone on the datestamp in email/task subject

v3.1.0 27/9/2016
Fixed issue with some File Upload ID's not being recognised

v3.0.9 26/09/2017
Fixed issue with text strings in answers being recognised as File Upload and converting to URL Bug report ZD#20765
Change the default filename of response spreadsheet when created to match the filename of the form

3.0.8 25/9/2017
Fixed output of Email/task body for Checkbox Grid and Matrix Grid to include question above answers.

v3.0.7 25/9/2017
Added ability to check if existing license is activated in Settings if re-running full setup wizard

v3.0.6 24/9/2017
Fixed issue with timezone not defaulting to proper time Bug report ZD#20720
Added functionality to Settings UI to specify different date formats for email/task subject
Fix for email sending error report if notification recipient left blank

v3.0.5 23/9/2017
Fixed issue with Step 2 of Setup Wizard not connecting to Asana on first attempt
Fixed issue with PAT encryption failing in UI if PAT is empty

v3.0.4 21/9/2017
Fixed issue with License activation email not sending if license owner is not defined
Fixed issue with other email templates qualifying who to send alerts to
Fixed issue with Email/task subject not completing for clients upgrading from v2 with old settings Bug report ZD#20784
Fixed issue with History Sheet now updating header row properly, especially if new fields added to form

v3.0.3 21/9/2017
Fixed issue with Email/task subject not completing for clients upgrading from v2 with old settings Bug report ZD#20784

v3.0.2 20/9/2017
Fixed issue with form editor attempting to run Setup Wizard and breaking the setup.  Blocked editors from running the Wizard.

v3.0.1 19/09/2017
Fixed issue with Unlimited licenses not applying if upgrading from V2 - Bug report ZD#20764
Fixed issue with Settings form field dropdown not loading - incorrect type detected Bug report ZD#20764

v3.0.0 19/09/2017
Major rewrite of the codebase
New Licensing model
New interface and setup wizard
New options for customising the email/task subject
New setup wizard controller
New version update controller
New licensing activation controller
Dashboard removed and Asana Task Checklist put into Response Sheet

V2.0.1 08/08/2017

Fix bug with Green license check tick box doesn't open when clicked in sidebar
Change Training Video button to go to Vimeo album
Replace intro video on trial screen with this new version
On “Open Task Checklist" in sidebar, on the popup window, changed the button to "Click Here to Open Task Checklist"
Add a button red "Upgrade to Pro" in the sidebar.  Disappears when a premium license is used
Make the active step bigger font


V2.0.0b 04/08/2017
Complete redesign of Setup Wizard
Complete redesign of Sidebar
Add multiple followers
Add multiple tags
Construct your task/email subject from variables and fields in the form
Find tabs in Revision spreadsheet based on Tab ID and store in Settings Tab

V1.0.4 12/04/2017

Make signup screen collect email into license file
Step 8 and Step 9 not working fixed
Step 9 pop up blocker fixed
Check the create new response sheet and dashboard as default
Email address validation in sign up

V1.0.3 07/04/2017
Bug in response full history fixed
Change pricing on signup screen
Auto space out the columns on the Dashboard
Checking Master Spreadsheet when response sheet unlinked
Making dashboard header bold
Change Setup UI to say "Connected" for the response sheet
Change pricing wording on RegistrationUI

V1.0.2 30/3/2017
Change the license process to store unique ID for trial for easy signup

V1.0.1 29/3/2017
Change the whole license check process to auto-activating trial and check license after 14 days
Changed license check UI to better display signup options

V1.0.0.005 29/3/2017
Added visual wait loader added in step 2 connecting dashboard

V1.0.0.004 29/3/2017
Move response sheet and dashboard after creation
Encrypt license status
Add header to sample data tab
Rename mastersheet dashboard notification

V1.0.0.003 20/3/2017
New tab for sample data / Form submission error fixed  / New registration screen

V1.0.0.002 20/3/2017
Fixed the error from email (timed trigger check license every 24 hours)

V1.0.0.001  20/3/2017
Auto Populate Dashboard with sample data

Details

Version: 50
Updated: February 28, 2018
Language: English