CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-docs
Lee
Lee

Reputation: 1

Take data from a Google sheet with Google App Script and organize it in a Google doc

In Sheets I have dates and events that I would like to publish in Docs with the events listed under MONTH - YEAR. The number of events can vary, though usually over 400 events over a 2 year period. Sheets has them all sorted, but I haven't programmed in JavaScript before as I have used Access to do this in the past (But it seems to be overkill to have Access just for this.) It seems that Google App Script is the only way to do it?

A sample of the Sheet is here https://docs.google.com/spreadsheets/d/1IYmdIZU9wEVgSr7l4UWzJE7xXgUEQQOHUVarBHCeWgI/edit?usp=sharing

A sample of the doc that I would like to make is here https://docs.google.com/document/d/1obF-OiRAQG_6WxwiCT5-GkvnjETsdYiMHB2SDGxDeKA/edit?usp=sharing

Upvotes: 0

Views: 103

Answers (1)

Wicket
Wicket

Reputation: 38425

From the question

It seems that Google App Script is the only way to do it?

Besides Google Apps Script, there are APIs for Google Sheets and Google Docs that you could use with several programming languages. For more details see

Upvotes: 1

Related Questions