App Icon
Save Form data to multiple Google Sheets. Create new Calendar Events. Many Email options. Create and attach PDFs.
Works with:
237,225
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
Additional information
Privacy policy
Terms of service
Data Director Original will ask for the permissions shown below. Learn more
Data Director Original will need access to your Google account
This will allow Data Director Original to :
See, edit, create, and delete only the specific Google Drive files you use with this app
See, edit, create, and delete all your Google Sheets spreadsheets
Send email on your behalf
View and edit events on all your calendars
See and download any calendar you can access using your Google Calendar
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
View and manage forms that this application has been installed in
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
A User of Data Director Original
May 9, 2018
Excellent app, havent used in anger yet, but seems to do some really good stuff. Was attracted to the add guest to calendar feature, but it can only add to a single event, in my use case the form submitter would register for which sessions they would attend and it would add to the different event based on responses, maybe something for a future version. Thanks for this add-on.
Is this review helpful?
Yes
No
Profile Picture
Virtual Learning Collaborative Go-VLC
November 6, 2017
Alan, I love your app! This app has streamlined processes and reduced my woman-hours in doing my job every day. I appreciate your quick respond and resolve time to my issues. Thank you so much for all you're doing to make tasks automated and efficient.
Is this review helpful?
Yes
No
Profile Picture
A User of Data Director Original
January 29, 2019
Help menu is poorly written and missing very specific info needed. Is not user friendly in the least when it comes to tying form data into specific tabs on a google sheet. In fact, you can't even specify a tab as the addon description claims...it automatically pushes form info Data_Director_1 tab and the settings don't allow you to change that. Only option is to choose which Sheet it connects with. Judging from the other reviews, it seems the email blast info stuff works good but if you're looking to populate a G-Sheet on multiple tabs from one form submission....DEFinitely look elsewhere!!
Is this review helpful?
Yes
No
Profile Picture
A User of Data Director Original
August 28, 2018
Great app. Solid conditional emails. Love being able to send edit links. I'm sure I have only just scratched the surface of this add-on. 5 Stars all the way. Wish list, A magic wand to turn multiple photos captured in a single "upload file" field into a useful hyperlink. My edit links column isn't filling out in any of my sheets. Works fine on the emails, just not the sheets.
Is this review helpful?
Yes
No
Profile Picture
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
Profile Picture
A User of Data Director Original
September 27, 2016
I love this add-on and have been using it for a month now but recently since 28th or 29th Aug 2016 on, my data became out of alignment in the google sheet (data_director). Initially all data will be allocated in each column regardless if the form entry was empty or filled up. But it is not the case now, if any form entry field is empty, it will take it as a non-field. Eg. I have 20 entry field (questions) but the person who enter the form has only answer 12 fields and the other 8 fields left empty. My respond on Data_Director Sheet will have only 12 column from that person. All are being squeeze into the first 12 column, so to say, my "edit URL" is in the 12th column. Imagine I have 20 responses daily and some may have different number of field left empty. My sheets become very messy. The worse part is that I Vlookup for such "Edit URL" but is unable to find it cause it may vary in different column. It was alright for the past one month but i have no idea why. Please fix it. I've also email you. Need the function to work asap, please. *Updated on 20 Sep 2016. Thank you Alan for the prompt reply and troubleshoot. It work perfectly now. Can I have a suggestion? Many times I will use the Edit URL to edit my form, and my form has many many pages which require loading when I am out, issit possible to provide a button to submit the form even half way (to update the form) without clicking all the way to the last page. Just hope it has this function or to show all pages so don't have to click through all pages just to update a single item.
Is this review helpful?
Yes
No
Profile Picture
A User of Data Director Original
August 18, 2017
Alan, been using your Data Director for a few days now and it's great. Very easy to use and really works. I set up an appending to a google sheet and set up an automated email to the email address in the form. I was impressed by how intuitive it was to set up the email using all the form fields.
Is this review helpful?
Yes
No
Profile Picture
A User of Data Director Original
June 12, 2017
I find Google forms a fantastic product and it is free. The big drawback has been the way that when the form results are sent to google Sheets the formatting does not work on new entries. Data Direct solves this glaring problem. The Data Direct splitting tab also now allows the result to be sent to any chosen sheet, on my new project I use a dropdown list with options for the user. When an option is selected the results are directed to the sheet that corresponds to the option selected. Wonderful for survey forms. The service I received from the developer Alan Wells was fantastic, I was helped every step of the way when incorporating this into my web site. The app is free, however I would gladly pay a monthly fee for this. If you would like to see how this works Email me an I will send you links to the relevant form on my website and the result index page my Email is digiquick@gmail.com. Great work Alan
Is this review helpful?
Yes
No
Profile Picture
Nate Welch
August 3, 2017
Add-ons are most successful when you have a great dev in the background. This add-on is awesome. Robust in features yet not impossible to set up and navigate. Support from dev is great. Please donate to keep these things alive and well.
Is this review helpful?
Yes
No
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
1-10 of 38
Search
Clear search
Close search
Google apps
Main menu