Feb 7, 2022 | Google Sheets API, Python
Buy Me a Coffee? Your support is much appreciated! Source Code (Export Dataset To Google Sheets From A Database): Source Code (Insert Records To A Dataset From Google Sheets):
Nov 29, 2021 | Google Sheets API, Python
Buy Me a Coffee? Your support is much appreciated! Source Code:
Jul 21, 2021 | Google Sheets API, Python
Buy Me a Coffee? Your support is much appreciated! PayPal Me: https://www.paypal.me/jiejenn/5 Venmo: @Jie-Jenn Source Code: Adding a filter request_body = { ‘requests’: [ { ‘setBasicFilter’: {...
May 17, 2021 | Google Sheets API, Python
In this tutorial, I am going to show you how to automate Pivot Table in Google Sheets with Google Sheets API in Python. Since there are many things you can do with a Pivot Table, I will divide the tutorial into multiple parts. What is a Pivot Table? A Pivot Table is a...
May 2, 2021 | Google Sheets API, Python
Buy Me a Coffee? Your support is much appreciated! PayPal Me: https://www.paypal.me/jiejenn/5 Venmo: @Jie-Jenn Source Code: from Google import Create_Service def run_batchUpdate_request(service, google_sheet_id, request_body_json): try: response =...
Apr 26, 2021 | Google Sheets API, Python
Buy Me a Coffee? Your support is much appreciated! PayPal Me: https://www.paypal.me/jiejenn/5 Venmo: @Jie-Jenn Source Code: from Google import Create_Service # source code is in the description CLIENT_SECRET_FILE = ‘<client secret file...