Skip to content

This repository contains a Python script that extracts a performance report from Yahoo Gemini API and uploads the data into Google Sheets.

Notifications You must be signed in to change notification settings

davidjinlee/Yahoo_Gemini_API_Google_Sheet

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 

Repository files navigation

Yahoo Gemini API (Upload into Google Sheet)

This repository contains a Python script that extracts a performance report (Last 31 Days) from Yahoo Gemini API and uploads the data into Google Sheets through the utilization of "pygsheets".

Overview

"FOLDER_PATH_TO_GOOGLE_JSON_FILE" must be replaced with the folder path to the json file that is created via the Google API console

"FOLDER_PATH_TO_YAHOO_JSON_FILE" must be replaced with the folder path to the json file that is created via the Yahoo Developer Network console.

"GOOGLE_SHEET_NAME" must be replaced with the name of the Google sheet that you wish to publish the data to.

Resources

Yahoo Developer Network -> https://developer.yahoo.com/gemini/

Google API Console -> https://console.cloud.google.com/apis/

yahoo_oauth -> https://github.com/josuebrunel/yahoo-oauth

pygsheets -> http://pygsheets.readthedocs.io/en/latest/

pandas -> https://pandas.pydata.org/

About

This repository contains a Python script that extracts a performance report from Yahoo Gemini API and uploads the data into Google Sheets.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages