How to merge multiple google docs from data in a spreadsheet

Question

I would like to make a script to merge multiple Google Docs (selected from data in a spreadsheet) and create a single merged document.

I know how to do this in Word/Excel and could write it PHP/MySQL but I really would like to try to keep this inside of Google Docs as we are trying to move our documents into the cloud.

I understand about how a the documents are named and how to open it using App Scripts but don't know if this is possible.

Here is an example of my sheet:

Name________ DocPt1_________DocPt2_________DocPt3
Steve_______ GoogleDocA1____GoogleDocB1____GoogleDocC1
Mike________ GoogleDocA1____GoogleDocB2____GoogleDocC1
Drew________ GoogleDocA2____GoogleDocB2____GoogleDocC2
Aaron_______ GoogleDocA2____GoogleDocB1____GoogleDocC1

The Script would then lookup each of the documents and copy the contents of each in order into a new document.

Is this even possible? This is my first venture into Google Apps Scripts.

Thanks for any guidance.

Robb

how about [importrange](https://support.google.com/docs/answer/3093340?hl=en)? — Fabricator, Jul 29 '14 at 00:23
I think he wants to merge text documents from a list. Not spreadsheets. — Serge insas, Jul 29 '14 at 05:35

score 0 · Accepted Answer · edited May 23 '17 at 12:29

0

This souldn't be too hard, have a look at the answer to this post to see how to merge any number of documents into one.

edited May 23 '17 at 12:29

Community

1
1

answered Jul 29 '14 at 08:38

Serge insas

45,904
7
105
131

How to merge multiple google docs from data in a spreadsheet

1 Answers1