The StarThinker project will no longer receive new solution contributions from the Google team.
Please read the full StarThinker Open Source Support Ends At Google article for more details.
Copy the contents of a query into a Google Sheet.
| Specify the sheet and the query. |
| Leave range blank or set to A2 to insert one line down. |
| The range is cleared before the sheet is written to. |
| To select a table use SELECT * FROM table. |
| Open Source | YES |
| Age | Aug. 7, 2019 (3 years, 4 months) |
| Authors | terwilleger@google.com |
| Shedule Days | Configured by user. |
| Shedule Hours | Configured by user. |
[
{
"bigquery": {
"auth": {
"field": {
"name": "auth_read",
"kind": "authentication",
"order": 1,
"default": "user",
"description": "Credentials used for reading data."
}
},
"from": {
"auth": "service",
"dataset": {
"field": {
"name": "dataset",
"kind": "string",
"order": 4,
"default": "",
"description": "Existing BigQuery dataset."
}
},
"query": {
"field": {
"name": "query",
"kind": "text",
"order": 5,
"default": "",
"description": "Query to pull data from the table."
}
},
"legacy": {
"field": {
"name": "legacy",
"kind": "boolean",
"order": 6,
"default": true,
"description": "Use Legacy SQL"
}
}
},
"to": {
"sheet": {
"field": {
"name": "sheet",
"kind": "string",
"order": 1,
"default": "",
"description": "Either sheet url or sheet name."
}
},
"tab": {
"field": {
"name": "tab",
"kind": "string",
"order": 2,
"default": "",
"description": "Name of the tab where to put the data."
}
},
"range": {
"field": {
"name": "range",
"kind": "string",
"order": 3,
"default": "",
"description": "Range in the sheet to place the data, leave blank for whole sheet."
}
}
}
}
}
]Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.