AJ Add-ons
•  164,504
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:
A User of Data Director
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
A User of Data Director
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
A user of Data Director
January 30, 2020
I'll find out what the issue is and publish a new version today.
A User of Data Director
November 30, 2019
Broken AGAIN
Is this review helpful?
Yes
No
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.
Is this review helpful?
Yes
No
A user of Data Director
January 20, 2020
Hello
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!
Is this review helpful?
Yes
No
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.
Is this review helpful?
Yes
No
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!!
Is this review helpful?
Yes
No
A User of Data Director
March 25, 2019
Easy to use, good results
Is this review helpful?
Yes
No
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!
Is this review helpful?
Yes
No
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!
Is this review helpful?
Yes
No
A user of Data Director
February 4, 2020
hallo how are you.
1-10 of 35
Additional information
AJ Add-ons
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu