Skip to content

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!

Notifications You must be signed in to change notification settings

C2L2C/Tg-2-sheets

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

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!

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages