Template
Google Sheets Export Example
An app to demonstrate how to export to Google Sheets
Industry:
n/a
Function:
Education & Training
This app demonstrates how to export to Google Sheets based on a template using Apps Script.
There are two examples:
Example 1 - Export Report: Copies columns of data from the data source and pastes them into the selected Sheet.
Example 2 - Generate Quote: Copies specific values from a record and pastes them into the template at defined locations.
It leverages the following Apps Script:
https://script.google.com/home/projects/1e98g5SqjMr6b6bvCzSkjJme0rSUlgsUF8yKRrl5bdTQ3F_IDeKLdGj-W
The template documents are here:
Sheets Report:
https://docs.google.com/spreadsheets/d/1isNo50c7aWEukNf1gD2wRTa4zHN7PX3T3ygRHZ-hBAQ/edit
Sheets Quote:
https://docs.google.com/spreadsheets/d/1n0KkiSXDw39BMRFEst2EjmEQ8WLhWWc2kCVX7Un-H48/edit
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
[This section usually shows the "Design Details" of the app, as defined in the Properties section of the app definition]
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...