/Tg-2-sheets

This simple python script fetches target groups (from elbv2 AWS API) and dumps it to google spreadsheets. You only need to provide the spreadsheet URL as input and you are good to go!

Primary LanguagePython

Tg-2-sheets

This simple python script fetches target groups (from elbv2 AWS API) and dumps it to google spreadsheets. You only need to provide the spreadsheet URL as input and you are good to go!

NOTE: I have built this using python v3.6. In case you are using an older version of python and run into issues, do let me know!

How to use:

  1. Clone the repo. git clone https://github.com/C2L2C/Tg-2-sheets.git

  2. Create a new google project, enable sheets API and generate credentials (credentials.json) as follows:

    Sheets API creds

    source: Google Spreadsheets and Python- Twilio

  3. Create a new google spreadsheet and share it with the email mentioned in the client_email field in credentials.json
    generated from step 2.

  4. Run the script as follows:

    python refreshTG.py
    
  5. Provide the spreadsheets URL, would look something like this: https://docs.google.com/spreadsheets/d/<spreadsheet_ID>/edit#gid=xxxxxxxx

  6. Provide the spreadsheet name.

  7. And you are done!

Thanks.