Help & Support
Send Feedback
Data Director
Save Form data to multiple Google Sheets. Create new Calendar Events. Many Email options. Create and attach PDFs.
153,017 users
Works with
Install
Overview
Data Director has the following features. 

* Sends Emails with Form answers merged into email
* Creates new Calendar Events
* Sends Calendar Invites to Guests
* Add Guests to Calendar Events
* Sends Form Answers to multiple Spreadsheets
* Create a new spreadsheet when conditions are met
* Creates a PDF - Attaches it to an email

More Details:

* Can send an email or not depending upon how a Form question is answered
* Will create a PDF file or not depending upon how a Form question is answered
* Create a new calendar event or not depending upon how a Form question is answered
* Save a PDF file to different folders depending upon how a Form question is answered
* Merge Form Answers into the Email
* Merge Form Answers into the PDF
* Merge Form Answers into the New Calendar Event
* Create an Edit URL and/or a PreFilled URL and save the link(s) to the destination spreadsheet, and/or put the links into an Email
* Send up to 4 differently designed emails
* Unlimited number of advanced conditional tests for sending an email or not
* Send an email to the email address collected from a Form field.
* Send an email to the signed in user on a Google account
* Advanced Email Options for 1) Reply To: 2) From: and 3) No-Reply
  Only available to accounts that have those capabilities
* Email design settings are saved to the Form, not your email account
* PDF design settings are saved to the Form
* The email body in the email design can include HTML

All of the major features work independently.  Use any one feature alone, or use all of them together.

   Data Director can send the Form response to an alternate spreadsheet.  It can send an email, or multiple emails.  It can add a guest to your calendar event, and it can create an entirely new calendar event.  The emails support HTML.  Email addresses can be static, (sent to the same address every time), or be dynamic, and come from the Form (Or both static and dynamic) Emails can be conditional.  In other words, you can send an email depending upon  how a form question was answered.  For example, if the person filling out the form chooses a name from a drop down list, conditions can be set to send an email to a specific email address.  There are lots of possibilities.  You could send an email to a particular email address based upon a department name, or a product choice.
     When your Google Form is submitted, the Data Director for Forms Add-on can get the last form submission, and save it to a second spreadsheet destination of your choice.  The destination spreadsheet can be any Google spreadsheet that your Google account has permission to write to.  For example: Your Google Form currently writes data to a spreadsheet, but you want the form response to also go into a second sheet in the same spreadsheet.  This Add-on can do that.  Or the Add-on can write a copy of the form response to a completely different spreadsheet.
     You should install this Add-on if you want to save a copy the form response to to a destination other than what is set in the Form's design.
     But that's not all Data Director can do!  Data Director will also create an Edit URL and/or a PreFilled URL, and save those links to the spreadsheet.

For information about the permissions needed use the following link:

Official Website: https://ajaddons.com#ddForm
Reviews
A User of Data Director
November 30, 2019
Broken AGAIN
Submit reply
Cancel
A user of Data Director
December 5, 2019
I have created a new Sheets add-on named Answer Router that I hope will be more reliable. Sometimes the "On Form Submit" trigger stops working with no warning. I'm not sure if that was the issue or not. That's the biggest issue affecting the add-on, which is out of my control. If that happens, open the sidebar and turn the button to red, wait for the message, and then turn the button to green, and run a test.
A User of Data Director
October 22, 2019
I like it when it works. randomly stops working for me though. I have this sending conditional emails on multiple forms and I have had to remake email templates several times as well as emails just not going out until I turn the add-on off and back on.
Submit reply
Cancel
A user of Data Director
December 5, 2019
I have created a new Sheets add-on named Answer Router that I hope will be more reliable. Yes, it does randomly stop working because of the "On Form Submit" trigger. That issue is a problem at Google. It definitely is a reliability problem. There's nothing I can do to the add-on code to fix it.
A User of Data Director
August 22, 2019
This app has made my life a lot easier. I use it to send a confirmation emails and to set up Calendar appointments in separate Calendars. Great work Alan Wells!
Submit reply
Cancel
A user of Data Director
December 5, 2019
Thank you. There is now a new add-on available for Sheets named Answer Router that does the same thing.
A User of Data Director
July 24, 2019
Was great until today when it stopped working. It is like the whole thing was updated and now I can't get it to put the data on my email and send it. Very frustrated.
Submit reply
Cancel
A user of Data Director
December 5, 2019
I have created a new Sheets add-on named Answer Router that I hope will be more reliable. I did need to make a lot of changes in order to comply with new more restrictive access to people's accounts. That caused some issues.
A User of Data Director
May 12, 2019
man!! Great App!!
Submit reply
Cancel
A User of Data Director
March 25, 2019
Easy to use, good results
Submit reply
Cancel
Cody Thompson
March 12, 2019
Like the add-on, and we have good success implementing it at our institution! However, we have noticed a recent problem with it not recognizing all-day events. The problem is that events without specific times (single day and multiple days) are not being pushed to the calendar. They show up on the Google Sheet, but there appears to be a lost connection with the calendar. However, events with specific start and stop times have no problem. Please help!
Submit reply
Cancel
A User of Data Director
February 24, 2019
Extremely useful app, thanks a lot! One low priority wish: when I slightly change time of an event in a form, and resubmit the form, new calendar event is created each time. Could existing calendar event be UPDATED instead? I guess there's a workaround by having a manual switch in a form, and use advance branching in "cal target section", but it's not that smooth. Anyway great job on the product!
Submit reply
Cancel
David Amatuni
February 16, 2019
This is a great app! So far I have only used it for emails and that works as intended. One suggestion I have is to be able to create a custom hyperlink text instead of the bare Edit / PreFilled URL, which can reach paragraph lengths in my case.
Submit reply
Cancel
A user of Data Director
August 23, 2019
The link for the edit and prefilled URLs can now have custom text for the email body.
Alan Wells
February 18, 2019
Thanks for the suggestion. I'm working on a paid version of the add-on, and a quota limited version of the add-on. I've added your request to my feature request notes. I've got quite a few feature requests that I've had for a while. Hopefully I'll be able to release some new updates in the future.
A User of Data Director
February 4, 2019
Solid app for sending emails, fully featured, and great support.
Submit reply
Cancel
A user of Data Director
February 5, 2019
Thank you for the feedback. I am still actively engaged in planning out a future for the add-on. There was a recent change in the email permission that has been causing some authorization errors that requires the add-on to be re-authorized. I've been sending out emails to accounts that are getting an error, informing them of the problem. Also, they G-Plus group is changing to https://plus.google.com/communities/113163111824328120978 The current G-Plus group for Data Director will be deleted by Google in April because it's in a free/ consumer account.
1-10 of 34
Additional information
Search
Clear search
Close search
Google apps
Main menu