App Icon
AJ Add-ons
•  186,693
Overview
Save Form data to multiple Google Sheets. Create new Calendar Events. Many Email options. Create and attach PDFs.
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
Language:
Sort by:
Profile Picture
A User of Data Director Original
July 7, 2020
Hi Alan my forms just quit working also two or three days ago i can not get to the app data director add on. Not in upper right corner of forms any longer do i need to reload add on? i do not have the ability to look at data director settings at this time? Any help please.
Is this review helpful?
Yes
No
Profile Pciture
A user of Data Director Original
August 11, 2020
Same
Profile Pciture
A user of Data Director Original
July 21, 2020
Same problem for us too!
Profile Pciture
A user of Data Director Original
July 20, 2020
Same problem here.
Profile Pciture
A user of Data Director Original
July 13, 2020
Same here. Stopped working for me on 7/9/2020. Shows that it is installed, but no "Puzzle piece" icon.
Profile Pciture
A user of Data Director Original
July 13, 2020
Yes It is not working now
Profile Pciture
A user of Data Director Original
July 13, 2020
same problem
Profile Pciture
A user of Data Director Original
July 10, 2020
Mine is also not working. I tried uninstalling and reinstalling and I receive error message "Sorry, the file you have requested does not exist."
Profile Pciture
A user of Data Director Original
July 10, 2020
Also not working for me. Any update?
Profile Pciture
A user of Data Director Original
July 8, 2020
Same problem that I'm having. Got a report that my form submissions weren't coming in, but the data is saving in my Google Sheets repository, which is weird.
Profile Pciture
A user of Data Director Original
July 8, 2020
Same problem. I tried uninstalling the add-on, and when I went to reinstall it, the link was broken.
Profile Picture
Dee Corbett -DoIT-
July 7, 2020
For some reason my data director is showing as installed but it failed to send an email and when I checked the form the app was gone.
Is this review helpful?
Yes
No
Profile Pciture
A user of Data Director Original
July 7, 2020
I seem to be having the same issue... the app shows as installed but as of today I can't find the menu and the responses aren't going where they're supposed to go anymore?
Profile Picture
A User of Data Director Original
February 10, 2020
This App is great. But there's just 1 problem on PDF, HTML is not working
Is this review helpful?
Yes
No
Profile Pciture
A user of Data Director Original
June 18, 2020
why does this app have to be horrible!!ahhhhhhhhh!
Profile Pciture
A user of Data Director Original
May 21, 2020
yes
Profile Pciture
A user of Data Director Original
April 23, 2020
thank you
Profile Picture
A User of Data Director Original
January 29, 2020
not working. I am using advanced data splitter, and when I want to add new condition and click save, it doesnt save...
Is this review helpful?
Yes
No
Profile Pciture
A user of Data Director Original
April 23, 2020
good
Profile Pciture
A user of Data Director Original
January 30, 2020
I'll find out what the issue is and publish a new version today.
Profile Picture
A User of Data Director Original
November 30, 2019
Broken AGAIN
Is this review helpful?
Yes
No
Profile Pciture
A user of Data Director Original
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.
Profile Picture
A User of Data Director Original
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.
Is this review helpful?
Yes
No
Profile Pciture
A user of Data Director Original
April 23, 2020
Wonderful
Profile Pciture
A user of Data Director Original
January 20, 2020
Hello
Profile Pciture
A user of Data Director Original
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.
Profile Picture
A User of Data Director Original
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!
Is this review helpful?
Yes
No
Profile Pciture
A user of Data Director Original
June 1, 2020
it is unavalble
Profile Pciture
A user of Data Director Original
December 5, 2019
Thank you. There is now a new add-on available for Sheets named Answer Router that does the same thing.
Profile Picture
A User of Data Director Original
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.
Is this review helpful?
Yes
No
Profile Pciture
A user of Data Director Original
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.
Profile Picture
A User of Data Director Original
May 12, 2019
man!! Great App!!
Is this review helpful?
Yes
No
Profile Picture
A User of Data Director Original
March 25, 2019
Easy to use, good results
Is this review helpful?
Yes
No
1-10 of 37
Additional information
AJ Add-ons
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu