Populate Google Docs template from Google Sheet data

[DrQuincy]

Hi all,

This is nothing to do with PW… I have some data in Google Sheets. Do you know if it's possible, ideally without having to use their API, to create Google Docs that automatically feed in data from certain sheets/cells.

E.g. A Google Sheet has a list of addresses that have address in one column and a “type” flag attached to them (e.g. rural, suburban, urban). Let's say there are 3 x types as mentioned. Is it possible to have 3 x Google Docs that feed in addresses filtered by type? And, ideally, if the data is updated in the Sheet it automatically progates into the Docs.

Can this be done? I have had a look but can't find anything. It looks like they have a decent enough API but it looks like it would take more work than I have time to spend on it.

Thanks.

[bobbit6k]

Something like this?

• Create as  many sheets as the number of different options in your cell
• Recall the filtered datas by using a query function like =QUERY(all_data!A:C; "select * where C = 'alpha'";1)

Now to make it in Gdocs:

• Open the Google Sheets spreadsheet that you want to embed into your Google Docs document.
• Highlight the data you want to copy, and select Edit > Copy or use the appropriate keyboard shortcut.
• Switch to your Google Docs document, click where you want to insert the table, and select Edit > Paste.
• A window will appear, allowing you to choose between "Link to spreadsheet" or "Paste unlinked." Selecting "Link to spreadsheet" will create a linked table that can be refreshed and updated if the original spreadsheet data changes (not automatically)

From now on, You can also setup the interval range but the downside is that you'll get a lot of empty lines if these cell contains no data.

I think this would be the cheapest option ?

[DrQuincy]

Oh wow, you are amazing, LOL!

That worked great. The only downside I can see if that I can't see a way of having a dynamic number of rows in the Google Doc. So I have to paste more than I need for the update to work. E.g. If I paste 10 rows in the Doc that limits it to 10. That should be okay but am I missing something that would allow me to have any numbers of rows pull through?

[bobbit6k]

Yeah i see your Point, i think this Will get hands on the Google apps scripting language!?