Thank you for providing this valuable resource to us. I searched tirelessly for an application that would allow me to create personalized document and specific email to +500 distinct entities and your add-on caused me to be successful. Thank You.
Download Document Studio workspace.google.com/marketplace/app/document_studio/429444628321 🚀 Check out the tutorials at digitalinspiration.com/docs/document-studio ✅ Developed by Google Developer Expert for Google Workspace and Google Apps Script
This is amazing. Thank you so much for sharing. You know what we need now? A cheat sheet with formulas. I waist most of my time trying to search for the correct formula cause I can't figure it out on my own. Some times it takes me so long that I give up. Thanks again.
Hi Amit, does document studio only work if I upgrade to premium? I installed the add-on and tried using it right off the bat and it doesn't seem to work. Please advise!
Hello! When I try to select a parent folder to upload the documents it doesn´t give me the option to pick one. There is no select folder button. Why would that happen?
Hi there! Thanks for the great video! I'm trying to merge my contacts from the Google spreadsheet to Google docs for a mailer that I'm sending out. I followed all the steps you shared up to clicking the "Run Merge" Button but nothing happened on the google docs side. Could you please advise! My goal is to merge the contacts to G Docs and print the letter with each client's name. Thank you!
I am having difficulty formatting the "Timestamp" in an EEEE DD, YYYY (March 3, 2018) fashion when I merge my Templates it gives me the 3/3/18 08:45:00. Is there a script or workaround for this?
Can this merge multiple documents from a single row? I would like to create a contract document, and two other documents. Three Google Doc in total from the same spreadsheet.
Hi there! I'm having trouble, where everything that is translating from my spreadsheet into my PDF document inserts the formatting marks as well ie. rather than just holding the formatting. HELP!
Dear Amit, your contributions are excellent. I wish to ADDON document studio to my existing form responses. I have the necessary fields like email and names etc. Can I simply go ahead with the responses sheet. Regards Manoj Gupta
Hi Amit It is really good ! Wondering if the google excel spreadsheet can consolidate with excel file to do some balance counting . Example : we are using google form to apply leave and the day of leave will be generate into google sheet . My question is - google sheet able to use some calculate function to calculate the leave balance itself after google sheet received the info from goggle form submitted ?
Hello, thanks for the video. Is it possible to place a sparkline in the googledoc. I tried putting the name of the sparkline function in between curly braces but it did not display the chart.
Really good add on and tutorial, however whenever run the merge it creates the document and send the email but it does not include the merged document? does anyone know how to fix this?
Hi, Your video is good but i would like to know what if the data which needs to be merged in google docs are on different tabs. Your video shows syncing data from 1 worksheet avaialable what if I need the data to be merged into google docs from various worksheet how will i refer the sheet name under tag {{}} to grab the data ?? can you help on this ? Thanks
Is there a way to use a google sheet to create ONE presentation file in google slides with multiple slides? Right now its creating multiple files for each row
Hello Amit, i notice i was only able to create one job, with the premium version I will be able to create multiple jobs???? (More than one Google Form and more than one instructions for the e-mail.
Hi Amit, Nice add on. I have one probs- When i run merge its saves on landscape mode even after i have done the selection on the template print tab as A4. Is there a way to select the merge pdf saves in A4 potrait mode pls
I am wanting to use this add on, to take information from google sheet to a google document purchase order, i need multiple lines added , but it creates a seperate document per line, is there an option to merge a few lines in one document??
Hi Amit, How to merge/create document for a single row of details. Whenever we add more rows and run document studio again, it will create documents for all the rows right? Not for the new row alone which was added recently. Expecting a solution
I am new to google studio and I'm trying to send a group email with each person having a unique attachment. I tested several email addresses and the same file attached to each one. Also when I entered text in the box for the attachment, there was no link. When I removed the text, there was a link to the attachment.
Unlike mail-merge, where each row is assigned to a unique output document, my lesson plans need to have each row assigned to sections of a single document (simplified example: beginning, middle, end; one document per day). Can that be done? How?
I appears that what you are showing in the video is NOT what I have from the install. Do I have to pay the 80.00's first before I can use the features of this program. Thank you in advance
Document Studio is not working sir It says Sign in with Google temporarily disabled for this app. This app has not yet been verified by Google in order to use Google Sign in. Please check the issue and help
I merged it, but after sending some emails, I got a message "Email sending paused". How long should I wait for the next run? Should I just wait or do something again after some time? Thanks for this great function.
I am impressed what Document Studio can do based on your video presentations. I'd like to merge Google Docs with Google Forms. The idea is to collect the e mail and then either give away a free e book and /or give access to a video. Is it possible with Document Studio? Pl do respond.
I get the following message when I try to install the app Sign in with Google temporarily disabled for this app This app has not been verified yet by Google in order to use Google Sign In. Please help!
Awesome add-on. Small question. How do you get it to work on 2 separate sheets? Whenever I change the merge setting in one sheet, it changed the settings for all.
This broke and no one's answering my support inquiries. It started only rendering the 1st 2 pages, the rest blank. Then it just stopped totally and gives an error in the Document studio link cells. Its totally broken on both Windows and Mac, Firefox and Chrome. I factory reset it, cleared cache, p-ram, restart computer, uninstalled addon and everything. Not working anymore and its sad because this was an incredible resource!!
Hi Amit thank you for the great Add-on. I have a question; I've been using the Document Studio add-on for over a year now and it was working fine, however I have recently noticed the system has for some reason begun creating a new subfolder path for each transaction. I now have multiple folders in my parent folder with the same name. Is there a way to resolve this?
Can you please open the Document Studio sidebar, switch to the Upload to Google Drive section, and reselect the folder where the files would be saved. For support, please contact us via digitalinspiration.com/support
We are enjoying this at work, however we ran into a problem. When sharing the file with another google account, the merged pdf file that gets emailed to recipient gets 2 emails! One from each google account that is on that shared file. HOW DO WE FIX THIS? Any help would be greatly appreciated.
Hi, would it be possible to add a cc from a merge field? for example, if I email a student, there could be a corresponding advisor I would need to keep informed (that would necessitate using data from 2 merge fields)
Hi Amit. SUPER helpful tutorial. I have a question I'm hoping you can answer. I have a need to maximize a single sheet of paper by creating 3 invoices per page. Do you know if it's possible to design a template that would allow me to do that? Currently it's repeating the same variable information for all fields on each page rather than resolving the variables sequentially. Thank you in advance!
सर बहुत ही उपयोगी जानकारी प्राप्त हुई। सर मेरा एक सवाल है इसी तरह गूगल फार्म से पीडीएफ के द्वारा डाटा कैसे प्राप्त किया जा सकता है जिसमें 3 रिक्वायरमेंट्स हों 1 सेलेक्ट month 2 select year 3 select name Pls help me Thanks in advance।
i did the custom certificate with gmass and autocrat to achieve something that was already done 4 years ago , but youtube didnt suggest this video, would have been easier
Hi, Can't add it! Error: Sign in with Google temporarily disabled for this app . This app has not been verified yet by Google in order to use Google Sign In.
Hey Amit, I use your tool extensively but this morning the add-on has disappeared from my google workspace! do you know whats happening? and how to fix??
Hi Andrew, I'm in the same position - the tool disappeared from my account this morning. Very hopeful for a response as this tool is pivotal to a number of processes at my organisation!
My name is Amit Agarwal and I am the developer of Document Studio. I am really sorry for the inconvenience since Document Studio is temporarily not available in the Google Store. We are working with the Google team to get this issue resolved as soon as possible. We will have an update for you as soon as we hear from them.
My name is Amit Agarwal and I am the developer of Document Studio. I am really sorry for the inconvenience since Document Studio is temporarily not available in the Google Store. We are working with the Google team to get this issue resolved as soon as possible. We will have an update for you as soon as we hear from them.
Hi @amit Sorry, my name is Patricio, I'm from Chile. I'm reaching you because I need help with a project I would appreciate your help. I'm not sure if this can be done with and how to do it, but maybe you can guide me. Well, I need to build kind of a system that allows users to create requirements. So in this context, the app needs to ask users different alternative questions and depending on the alternative they choose, show them another question. So putting it in simple words, the app has a "decision tree" behavior". So that's the first thing. The second thing I need to do, is in some of the questions that the app is asking to the user over the journey, might need him to insert text (for example, his name, email address, etc) and/or upload some files (could be an image a pdf or doc files). So until now, it is a combination of alternative/answers questions, text answers, and file uploadings, around a "decision tree" behavior dynamic. Ok, here comes the challenge. I need to feed a pdf file with the information I'm getting from the answers that the user is giving and the information that he is completing in the questions that require filling a text field. So when the user starts the journey, while he is advancing with the process, in parallel a pdf file ("requirement request") will begin to be completed in those varial and/or parameterized fields that require the information that the user is providing. Ok, next step. In the last step of the journey, when we have all the information required by the user, two things need to happen before the journey ends. 1. The user will be introduced with a registration/login view needed to proceed with his requirement. 2. Once step number 1 is completed, the pdf will be already filled and has to be automatically sent to the user's email and to me (LOL). With this, a folder with the name of the user should be created automatically on my Google Drive, containing this pdf with a description that begins with the date and time to identify it. Additionally, if the same user were to make the journey again, the new pdf document that originates must not replace the previous one, so this is why the date and time over the name of the document are very important. Then the process is concluded. Ok, one last thing here, that might be a little bit tough, some of the files that are asked to the user to be uploaded need be attached in the same pdf "requirement request" as Annexes.
This is not useful whenever I watch the video to learn about the Google Forms part of the process, and you say you're skipping that part. It's just that the name is misleading, and now I'll have to look elsewhere for a solution to my problem.
Sadly i think Amit is a victim of his own success. I have tried to contact him/support numerous times via different methods. The product looks great, but i am not prepared to implement something without a true support mechanism. Was happy to purchase an annual domain license, but wanted a few questions answered, pity as it looks like a workable product, we both lose.
Genius. So fully integrated -- the fact that the variables work EVERYWHERE. And such a smooth, clean interface. You, sir, are a genius.
Extremely clean and simple. Keep up the good work.
Thank you so much. You saved me a ton of time and money too. There's so many paid versions of this extention :o. This was the easiest and cheapest.
Thank you, Amit. Super amazing integration. Complete and concise. All the best. Namaste, Sahib.
Thank you for providing this valuable resource to us. I searched tirelessly for an application that would allow me to create personalized document and specific email to +500 distinct entities and your add-on caused me to be successful. Thank You.
Download Document Studio workspace.google.com/marketplace/app/document_studio/429444628321 🚀
Check out the tutorials at digitalinspiration.com/docs/document-studio ✅
Developed by Google Developer Expert for Google Workspace and Google Apps Script
Is it hipaa compliant?
Upon Download it says, Google sign in is temporarily disabled. Please fix this
@@albertclemstva.c.t210 The addon is now verified by Google.
This is amazing. Thank you so much for sharing. You know what we need now? A cheat sheet with formulas. I waist most of my time trying to search for the correct formula cause I can't figure it out on my own. Some times it takes me so long that I give up. Thanks again.
What a brilliant add-on. Well done and tank you.
Wow! thank you so much for this video!!
Hi Amit, does document studio only work if I upgrade to premium? I installed the add-on and tried using it right off the bat and it doesn't seem to work. Please advise!
Thank you sir. I learn much from your chanel. GBU
to know if I ask to make pdf every hour I have to rename my pdf each time in merge or it is done automatically?
Hello! When I try to select a parent folder to upload the documents it doesn´t give me the option to pick one. There is no select folder button. Why would that happen?
Great product, when filters are enabled, can the application be setup so that it only creates forms to entries that meet the filter criteria?
Thank You. This is very useful.
Hi there! Thanks for the great video! I'm trying to merge my contacts from the Google spreadsheet to Google docs for a mailer that I'm sending out. I followed all the steps you shared up to clicking the "Run Merge" Button but nothing happened on the google docs side. Could you please advise! My goal is to merge the contacts to G Docs and print the letter with each client's name. Thank you!
I am having difficulty formatting the "Timestamp" in an EEEE DD, YYYY (March 3, 2018) fashion when I merge my Templates it gives me the 3/3/18 08:45:00. Is there a script or workaround for this?
Thanks for your addon. Can I add digital signature on PDF file generated?
is it possible to allow users to fill a dynamic table ( i mean that they could set the number of rows and columns )
Can this merge multiple documents from a single row?
I would like to create a contract document, and two other documents. Three Google Doc in total from the same spreadsheet.
very useful Amit, thank you
Hi there! I'm having trouble, where everything that is translating from my spreadsheet into my PDF document inserts the formatting marks as well ie. rather than just holding the formatting. HELP!
I would love to try this add on but I get an error when I try to download it that says Google sign in is temporarily disabled.
Dear Amit,
your contributions are excellent. I wish to ADDON document studio to my existing form responses. I have the necessary fields like email and names etc. Can I simply go ahead with the responses sheet.
Regards
Manoj Gupta
Hi Amit
It is really good !
Wondering if the google excel spreadsheet can consolidate with excel file to do some balance counting . Example : we are using google form to apply leave and the day of leave will be generate into google sheet . My question is - google sheet able to use some calculate function to calculate the leave balance itself after google sheet received the info from goggle form submitted ?
Hello, thanks for the video. Is it possible to place a sparkline in the googledoc. I tried putting the name of the sparkline function in between curly braces but it did not display the chart.
Really good add on and tutorial, however whenever run the merge it creates the document and send the email but it does not include the merged document? does anyone know how to fix this?
Hi,
Your video is good but i would like to know what if the data which needs to be merged in google docs are on different tabs. Your video shows syncing data from 1 worksheet avaialable what if I need the data to be merged into google docs from various worksheet how will i refer the sheet name under tag {{}} to grab the data ??
can you help on this ?
Thanks
Is there a way to use a google sheet to create ONE presentation file in google slides with multiple slides? Right now its creating multiple files for each row
Hello Amit, i notice i was only able to create one job, with the premium version I will be able to create multiple jobs???? (More than one Google Form and more than one instructions for the e-mail.
This is great! How does one consolidate multiple rows of data into a single page of a doc?
Hi Amit, Nice add on. I have one probs- When i run merge its saves on landscape mode even after i have done the selection on the template print tab as A4. Is there a way to select the merge pdf saves in A4 potrait mode pls
I am wanting to use this add on, to take information from google sheet to a google document purchase order, i need multiple lines added , but it creates a seperate document per line, is there an option to merge a few lines in one document??
Hi Amit,
How to merge/create document for a single row of details. Whenever we add more rows and run document studio again, it will create documents for all the rows right?
Not for the new row alone which was added recently. Expecting a solution
Best👍👍👍 single stop automation ever
this is amazing
I am new to google studio and I'm trying to send a group email with each person having a unique attachment. I tested several email addresses and the same file attached to each one. Also when I entered text in the box for the attachment, there was no link. When I removed the text, there was a link to the attachment.
I cant find the add on anymore - I have payed for it but no the add on is not to be found anymore on the Add-o page - whats happening?
Unlike mail-merge, where each row is assigned to a unique output document, my lesson plans need to have each row assigned to sections of a single document (simplified example: beginning, middle, end; one document per day). Can that be done? How?
Is it possible to create single file with all responses submitted through Google forms??
Can we use forms for multiple users?
I appears that what you are showing in the video is NOT what I have from the install. Do I have to pay the 80.00's first before I can use the features of this program. Thank you in advance
Document Studio is not working sir It says Sign in with Google temporarily disabled for this app.
This app has not yet been verified by Google in order to use Google Sign in.
Please check the issue and help
Can I merge the pdf generated from responses of the google form with documents uploaded in the same google form?
Is there any way I can send a set of tabulated data for each person?
sir . please explain how to insert image in google docs , uploaded by a user in google form response
It is removed from add on.!so how can i use document studio now?
Brilliant!!
I merged it, but after sending some emails, I got a message "Email sending paused". How long should I wait for the next run? Should I just wait or do something again after some time? Thanks for this great function.
Sign in with Google temporarily disabled for this app
This app has not yet been verified by Google in order to use Google Sign in.
how would I use this, but for grouped data. I.e. at each change of employee, send all the rows for that employee.
I am impressed what Document Studio can do based on your video presentations. I'd like to merge Google Docs with Google Forms. The idea is to collect the e mail and then either give away a free e book and /or give access to a video. Is it possible with Document Studio? Pl do respond.
I get the following message when I try to install the app
Sign in with Google temporarily disabled for this app
This app has not been verified yet by Google in order to use Google Sign In.
Please help!
Thanks You Amit....
Merge multiple rows of billing info into one document/invoice, is that possible?
Awesome add-on. Small question. How do you get it to work on 2 separate sheets? Whenever I change the merge setting in one sheet, it changed the settings for all.
We are working on a new version of Document Studio where you will be able to define configuration per form, per sheet.
@@labnol This is awesome. Is this version ready ?
great work
This broke and no one's answering my support inquiries. It started only rendering the 1st 2 pages, the rest blank. Then it just stopped totally and gives an error in the Document studio link cells. Its totally broken on both Windows and Mac, Firefox and Chrome. I factory reset it, cleared cache, p-ram, restart computer, uninstalled addon and everything. Not working anymore and its sad because this was an incredible resource!!
What happen if a cell in sheet is edited and export file is a pdf ..
Sir,i want to link Vendor data to PO link Which feel atumatic form in PO link,,how is possible
Hi Amit thank you for the great Add-on. I have a question; I've been using the Document Studio add-on for over a year now and it was working fine, however I have recently noticed the system has for some reason begun creating a new subfolder path for each transaction. I now have multiple folders in my parent folder with the same name. Is there a way to resolve this?
Can you please open the Document Studio sidebar, switch to the Upload to Google Drive section, and reselect the folder where the files would be saved. For support, please contact us via digitalinspiration.com/support
Is the Doucment Studio discontinues now at the GSuite market ?
Document studio add one is now not available
We are enjoying this at work, however we ran into a problem. When sharing the file with another google account, the merged pdf file that gets emailed to recipient gets 2 emails! One from each google account that is on that shared file. HOW DO WE FIX THIS? Any help would be greatly appreciated.
Hi Amit, great instructions, but when I get to the part where it selects the document template, every time I press select my document nothing happens.
Can you please email amit@labnol.org and we'll get back to you.
Hi, would it be possible to add a cc from a merge field? for example, if I email a student, there could be a corresponding advisor I would need to keep informed (that would necessitate using data from 2 merge fields)
You can add a new column in the sheet and give the title as CC or BCC. It will be added to CC or BCC in the email.
Hi Amit. SUPER helpful tutorial. I have a question I'm hoping you can answer. I have a need to maximize a single sheet of paper by creating 3 invoices per page. Do you know if it's possible to design a template that would allow me to do that? Currently it's repeating the same variable information for all fields on each page rather than resolving the variables sequentially. Thank you in advance!
you can just choose to print multiple pages in a sheet
Been meaning to ask this - what software do you use for screen capture?
This is done with both Camtasia Studio and ScreenFlow
Hello, what are the limits of the free version? I only found the payment plans. Sheets shows me Error: No email quota available.
On Download it says Google Sign in is temporarily disabled. How can I use this Ad on
Dhruv Badruka i am in same problem
Same here!
Its fixed!
hi sir help me pls...
images missing after create pdf by slide template, how to fix this problem
thx u ..
Can't seem to get multiple choice answers to show up in the merged document. Is there a special way to do that?
Did you ever figure it out I’m trying too
The add-on is free?
Excellent
Hi Amit
Document studio addon create only 20 documents free per day.
So
Is there any free version like this addon
सर बहुत ही उपयोगी जानकारी प्राप्त हुई।
सर मेरा एक सवाल है
इसी तरह गूगल फार्म से पीडीएफ के द्वारा डाटा कैसे प्राप्त किया जा सकता है जिसमें 3 रिक्वायरमेंट्स हों
1 सेलेक्ट month
2 select year
3 select name
Pls help me
Thanks in advance।
Does this still work with Google Forms merge?
U r genius
How can we show a photo in google slides? It is a URL in the google sheets, but I want to show it up for each document ( Different photos)
I have the same proble, have you fix it?
what happen? it dessapear?
Hi Amit , how many merged emails can be sent per day?
i did the custom certificate with gmass and autocrat to achieve something that was already done 4 years ago , but youtube didnt suggest this video, would have been easier
Superb
Very good
Hi,
Can't add it!
Error: Sign in with Google temporarily disabled for this app
.
This app has not been verified yet by Google in order to use Google Sign In.
The add-on is great!
Please, update your certificate/status.
Is document studio still available in the webstore? not finding it :(
Please find it at digitalinspiration.com/get/GA16
Nice..
hi thanks , the problem (Invalid email) how i can slove ???
You should check the Document Studio logs section for details on the error.
How to I select Excel as an output format?
If you have selected a Google spreadsheet as the source template, you can generate output files in Microsoft excel XSLX format.
Hey Amit, I use your tool extensively but this morning the add-on has disappeared from my google workspace! do you know whats happening? and how to fix??
Hi Andrew, I'm in the same position - the tool disappeared from my account this morning. Very hopeful for a response as this tool is pivotal to a number of processes at my organisation!
My name is Amit Agarwal and I am the developer of Document Studio.
I am really sorry for the inconvenience since Document Studio is temporarily not available in the Google Store. We are working with the Google team to get this issue resolved as soon as possible. We will have an update for you as soon as we hear from them.
Did document studio just disappear?
My markers is zero. Why
I din not find your adone in Google work space
My name is Amit Agarwal and I am the developer of Document Studio. I am really sorry for the inconvenience since Document Studio is temporarily not available in the Google Store.
We are working with the Google team to get this issue resolved as soon as possible. We will have an update for you as soon as we hear from them.
What's happen to Document Studio? it doesn't work on my Google
The app is now available!
Hi @amit
Sorry, my name is Patricio, I'm from Chile. I'm reaching you because I need help with a project I would appreciate your help.
I'm not sure if this can be done with and how to do it, but maybe you can guide me.
Well, I need to build kind of a system that allows users to create requirements. So in this context, the app needs to ask users different alternative questions and depending on the alternative they choose, show them another question. So putting it in simple words, the app has a "decision tree" behavior".
So that's the first thing. The second thing I need to do, is in some of the questions that the app is asking to the user over the journey, might need him to insert text (for example, his name, email address, etc) and/or upload some files (could be an image a pdf or doc files).
So until now, it is a combination of alternative/answers questions, text answers, and file uploadings, around a "decision tree" behavior dynamic.
Ok, here comes the challenge. I need to feed a pdf file with the information I'm getting from the answers that the user is giving and the information that he is completing in the questions that require filling a text field. So when the user starts the journey, while he is advancing with the process, in parallel a pdf file ("requirement request") will begin to be completed in those varial and/or parameterized fields that require the information that the user is providing.
Ok, next step. In the last step of the journey, when we have all the information required by the user, two things need to happen before the journey ends.
1. The user will be introduced with a registration/login view needed to proceed with his requirement.
2. Once step number 1 is completed, the pdf will be already filled and has to be automatically sent to the user's email and to me (LOL). With this, a folder with the name of the user should be created automatically on my Google Drive, containing this pdf with a description that begins with the date and time to identify it. Additionally, if the same user were to make the journey again, the new pdf document that originates must not replace the previous one, so this is why the date and time over the name of the document are very important.
Then the process is concluded.
Ok, one last thing here, that might be a little bit tough, some of the files that are asked to the user to be uploaded need be attached in the same pdf "requirement request" as Annexes.
It does not working
How can we create labels
Gmail labels cannot be created with Document studio.
@@labnol sir, not gmail level. I'm taking about mailing level, address level
This is not useful whenever I watch the video to learn about the Google Forms part of the process, and you say you're skipping that part. It's just that the name is misleading, and now I'll have to look elsewhere for a solution to my problem.
Sadly i think Amit is a victim of his own success. I have tried to contact him/support numerous times via different methods. The product looks great, but i am not prepared to implement something without a true support mechanism. Was happy to purchase an annual domain license, but wanted a few questions answered, pity as it looks like a workable product, we both lose.
Hi sir Gd morning
Can we talk ?