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.



All

perm_phone_msg Trends Places To Sheets Via Values

Move using hard coded WOEID values.



lock_openGet Access listGit Hub sourcePython menu_bookColab airAirflow



Instructions

Provide Twitter Credentials.
Provide a comma delimited list of WOEIDs.
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.

Details

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"
                }
            }
        }
    }
]


Run This Workflow In Minutes On Google Cloud

Everything from a quick Google Cloud UI to reference developer code for your team in one GitHub repository.

Deployment Stepslaunch Developer Guidebuild UI How Tolaptop