App Icon
AJ Addons
•  34,641
Send emails. Create and attach PDF files. Save Form data to different spreadsheets. Create calendar events.
Data Director has the following features. 

* Sends Emails
* Creates new Calendar Events
* Sends Form Data to multiple Spreadsheets
* Create new spreadsheet when conditions are met
* Creates a PDF - Attaches it to an email
* Adds a Guest to a Calendar Event
* Start Accepting Form submissions at a certain Date/Hour
* Automatically Stop Form submissions at a certain Date and Hour

This add-on is a beta version for testing new features.
See other add-ons:

Data Director
Answer Router Legacy 1

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:
Sort by:
Profile Picture
A User of Data Director
July 28, 2020
I love the app, but at this moment have too many failures.... Please help with that. After 4 days working it suddenly stops sending emails. At this moment I cannot go to settings, because it is only showing the help item and not the settings item...
Is this review helpful?
Profile Pciture
A user of Data Director
August 9, 2020
I apologize for the failures. It's extremely unlikely that the add-on will ever have the same problem again. I've made changes, and put procedures in place to make sure that the add-on is reliable from this point forward. The original Data Director was published from a free Google account, but now it's published from my G Suite account. That does make a big difference in the ability to manage the add-on.
Profile Pciture
A user of Data Director
August 6, 2020
I second to that... Here the same thing. No settings items, and was automatically removed from all my forms as well
Profile Picture
Sonia Furini
July 11, 2020
A great add-on with multiple functions. The developer, Alan is phenomenally responsive and attentive to this app!
Is this review helpful?
1-2 of 2
Additional information
AJ Addons
Terms of Service
Clear search
Close search
Google apps
Main menu