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.
Move using a WOEID query.
| Provide Twitter Credentials. |
| Provide BigQuery WOEID source query. |
| Specify Sheet url and tab to write API call results to. |
| Writes: WOEID, Name, Url, Promoted_Content, Query, Tweet_Volume |
| Note Twitter API is rate limited to 15 requests per 15 minutes. So keep WOEID lists short. |
| Open Source | YES |
| Age | June 6, 2018 (4 years, 7 months) |
| Authors | kenjora@google.com |
| Shedule Days | Configured by user. |
| Shedule Hours | Configured by user. |
[
{
"twitter": {
"auth": {
"field": {
"name": "auth_write",
"kind": "authentication",
"order": 1,
"default": "service",
"description": "Credentials used for writing data."
}
},
"secret": {
"field": {
"name": "secret",
"kind": "string",
"order": 1,
"default": ""
}
},
"key": {
"field": {
"name": "key",
"kind": "string",
"order": 2,
"default": ""
}
},
"trends": {
"places": {
"single_cell": true,
"bigquery": {
"dataset": {
"field": {
"name": "places_dataset",
"kind": "string",
"order": 3,
"default": ""
}
},
"query": {
"field": {
"name": "places_query",
"kind": "string",
"order": 4,
"default": ""
}
},
"legacy": {
"field": {
"name": "places_legacy",
"kind": "boolean",
"order": 5,
"default": false
}
}
}
}
},
"out": {
"sheets": {
"sheet": {
"field": {
"name": "destination_sheet",
"kind": "string",
"order": 6,
"default": ""
}
},
"tab": {
"field": {
"name": "destination_tab",
"kind": "string",
"order": 7,
"default": ""
}
},
"range": "A1"
}
}
}
}
]Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.