GitHub - xdevplatform/ETL: An example app demonstrating storing Tweets in a Google Spreadsheet | Latest TMZ Celebrity News & Gossip | Watch TMZ Live
Skip to content

xdevplatform/ETL

Repository files navigation

Code Examples for using Twitter API v2

Extract Transform and Load

Follow this tutorial

(TODO: @duckranger add details)

  1. Clone this repository
  2. Run npm install in the repo's directory
  3. Obtain a json key file for Google API (See https://www.fastcomet.com/tutorials/nodejs/google-spreadsheet-package) and place it inside the config directory
  4. Obtain a Twitter access token
  5. Create a Google Spreadsheet and get its id (The last part of the url: https://docs.google.com/spreadsheets/d/xxxxxxx)
  6. Make sure to share the sheet with client_email from within the Google json key file
  7. npm start

Environment Variables

The code relies on the following variables to be available, e.g. by using an .env file.

TW_BEARER_TOKEN=<A Twitter API v2 bearer token>
TW_TERM=<A search term>
TW_HASHTAG=<A tag (without the # sign)>
TW_GOOGLE_DOC_ID=<The Google Sheet id to use>

It also requires the Google json keyfile to be stored in /config/client_secret.json

About

An example app demonstrating storing Tweets in a Google Spreadsheet

Topics

Resources

License

Code of conduct

Stars

Watchers

Forks

TMZ Celebrity News – Breaking Stories, Videos & Gossip

Looking for the latest TMZ celebrity news? You've come to the right place. From shocking Hollywood scandals to exclusive videos, TMZ delivers it all in real time.

Whether it’s a red carpet slip-up, a viral paparazzi moment, or a legal drama involving your favorite stars, TMZ news is always first to break the story. Stay in the loop with daily updates, insider tips, and jaw-dropping photos.

🎥 Watch TMZ Live

TMZ Live brings you daily celebrity news and interviews straight from the TMZ newsroom. Don’t miss a beat—watch now and see what’s trending in Hollywood.