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.
Import data from a sheet and move it to a BigQuery table.
| For the sheet, provide the full edit URL. |
| If the tab does not exist it will be created. |
| Empty cells in the range will be NULL. |
| Check Sheets header if first row is a header |
| Open Source | YES |
| Age | Dec. 5, 2017 (5 years) |
| Authors | mauriciod@google.com |
| Shedule Days | Configured by user. |
| Shedule Hours | Configured by user. |
[
{
"sheets": {
"auth": {
"field": {
"name": "auth_read",
"kind": "authentication",
"order": 0,
"default": "user",
"description": "Credentials used for reading data."
}
},
"sheet": {
"field": {
"name": "sheets_url",
"kind": "string",
"order": 2,
"default": ""
}
},
"tab": {
"field": {
"name": "sheets_tab",
"kind": "string",
"order": 3,
"default": ""
}
},
"range": {
"field": {
"name": "sheets_range",
"kind": "string",
"order": 4,
"default": ""
}
},
"header": {
"field": {
"name": "sheets_header",
"kind": "boolean",
"order": 9,
"default": true
}
},
"out": {
"auth": {
"field": {
"name": "auth_write",
"kind": "authentication",
"order": 1,
"default": "service",
"description": "Credentials used for writing data."
}
},
"bigquery": {
"dataset": {
"field": {
"name": "dataset",
"kind": "string",
"order": 5,
"default": ""
}
},
"table": {
"field": {
"name": "table",
"kind": "string",
"order": 6,
"default": ""
}
}
}
}
}
}
]Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.