/docs/community?hl=en
This content is likely not relevant anymore. Try searching or browse recent questions.
Turn a google spreadsheet into a google document using a specific format 2 Recommended Answers 10 Replies 1 Upvote
1 Recommended Answer
$0 Recommended Answers
1 Relevant Answer
$0 Relevant Answers
Hey all.

I was wondering if there is anyway to export a google sheet in a per tab, per row basis into a google document.

Here is what I would want to do:
Create a spreadsheet with the tab 1,2,3 and a data tab.
Each tab has the same Columns for example A B and C.
Each row will have a different entry permitted into it. Some may leave C blank, this shouldn't be an issue later.

Now I want to export only tabs 1,2,3 into a google doc to show up as
Heading 1 --> tab 1
{
Heading 2 data in tab 1's A field
plain text of tab 1's B field (in italics)
A hard stop
plain text of tab1's C field
}
Repeating the section within curly  braces until all rows have been exported.

Now perform the same task for tabs 2 and 3.

Would anyone know of a good way to do this?

I was considering exporting the data to a txt file and then writing some code to do most of it, but I don't see a good way to add in the template data for headings, colors, italics ect
Relevant Answer Relevant Answers (0)
All Replies (10)
Relevant Answer
Hi TDSrock,
 
This can be done by using a Sheets mail merge add-on that is linked to your Form.  The add-on will use a column within the linked Sheet to determine when and which kind of email should be sent.  If you are not sure how to setup the column that will trigger the sending of the email, take a look at this post about Best Practices When Asking a Question and share a sheet that has the permissions set for “Anyone with link can EDIT”.  Here are some instructions for how to install an add-on.
___________________________
Add-ons are little “apps” that can add capabilities and functions to all of the different Google Docs products.  To find add-ons you first need to open a Doc, Sheet, Form, or Slide. In the top menu bar, you will find “Add-ons”, click on this and then “Get add-ons…”  In the search window found in the top right-hand corner, type in either the type or name of the add-on you wish to look for. When you find what you would like to use, click on the blue “+FREE” button and then follow the instructions to give the add-on access to your data. (See image below)  Be sure to read what the add-on will be accessing and if you do not want to grant permission for some items, do not continue to install the add-on. Once the add-on is installed, you can then begin to use it by going to the “Add-ons” menu and then selecting the specific add-on you want to use. Also, if you cannot find a specific name or type of add-on, you are probably looking in the wrong add-on area.  I know, this is a bit confusing at first and when you are dealing with two different Google Productions at the same time (ie Sheets and Docs), it can get more confusing.  Instead of housing all of the add-ons in one catalog, they are divided up into the specific Google Product that will use the add-on. So, there is a catalog for Docs, Sheets, Forms, and Slides and they are only accessible by opening the specific type of file you are working with and going to the “Get add-ons…” menu item.  For example, mail merge add-ons can be found in both Sheets (currently 58 possibilities) and Docs (currently 21 possibilities) and they are not the same add-ons. [Side note - when looking for mail merge add-ons, I would suggest using a Sheets add-on.] The moral of the story is if you cannot find something you are looking for in Docs add-ons, it might be in one of the other add-on catalogs.
 
_________________________________
 
I hope this helps!
 
Adam
Diamond PE Docs volunteer
Silver PE Classroom volunteer
Cert. Educator 1 & 2
Cert. Trainer
(not a Google employee)
 
When you've received a response that answers your question, please observe these forum courtesies:
 • If you had a Sheets problem, leave your demo sheet shared as View Only as part of this solution's archive,
 • Click Recommend on the post that best addressed your question, and
 • Post again soon!
marked this as an answer
Relevant Answer
I've tried GMerge plus, which gets really close to what I want to do. The biggest problem with that add-on is that it is putting each row into it's own file.

I want every row to be in one file. If I have to then go through each tab in the sheet and join them by-hand, bohoo, that's a small issue. But I can't merge 100's of different files together in 1, that's not worth my time. Any recommendations?
marked this as an answer
Relevant Answer
Without seeing an example of how your data is truly structured within a sheet and the final result that you are looking for, I'm not able to give you any other suggestions.  If you would share a sample of the Sheet and final result you are looking for, I, or another volunteer, may be able to come up with a solution for you.
 
Adam
marked this as an answer
Relevant Answer
I am currently using this as the template.

I am using the School of Void tab to test stuff in this sheet.

The result should be each row's data in a single file each beneath one another.
marked this as an answer
Relevant Answer
I'm glad I could help.  Good luck with the project!
 
Adam
marked this as an answer
This question is locked and replying has been disabled.
Discard post? You will lose what you have written so far.
Write a reply
10 characters required
Failed to attach file, click here to try again.
Discard post?
You will lose what you have written so far.
Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.
Create Reply
Edit Reply
Delete post?
This will remove the reply from the Answers section.
Notifications are off
Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.
Report abuse
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
Report post
What type of post are you reporting?
Google takes abuse of its services very seriously. We're committed to dealing with such abuse according to the laws in your country of residence. When you submit a report, we'll investigate it and take the appropriate action. We'll get back to you only if we require additional details or have more information to share.

Go to the Legal Help page to request content changes for legal reasons.

Reported post for abuse
Unable to send report.
This reply is no longer available.
/docs/threads
//accounts.google.com/ServiceLogin
You'll receive email notifications for new posts at
Unable to delete question.
Unable to update vote.
Unable to update subscription.
You have been unsubscribed
Deleted
Unable to delete reply.
Removed from Answers
Marked as Recommended Answer
Removed recommendation
Undo
Unable to update reply.
Unable to update vote.
Thank you. Your response was recorded.
Unable to undo vote.
Thank you. This reply will now display in the answers section.
Link copied
Locked
Unlocked
Unable to lock
Unable to unlock
Pinned
Unpinned
Unable to pin
Unable to unpin
Marked
Unmarked
Unable to mark
Reported as off topic
/docs/profile/0