how to use google drive apps script for spreadsheets

Security: no need to store credentials, proprietary source code, or other sensitive data in Google Sheets.

Scheduler: run your Python scripts automatically (e.g.

Authorization: leverage the Google identity and restrict certain functionality to specific users or groups.

Ease of use: no need for a Google Cloud Platform project, a credentials file, or sharing with a specific user.

Apart from sparing you the frontend work, this approach comes with a couple of nice features, such as: The whole thing is really just a web app with a Google Sheets frontend (yes, it works with your favorite web framework!). So I went ahead and added Google Sheets support to xlwings: instead of using the Sheets API to talk from Python to Google Sheets, xlwings goes the other way around and talks from Google Sheets to Python. I, however, was missing the Google Apps Script experience in Python, i.e., I wanted to develop interactive spreadsheet apps directly in Google Sheets. Nevertheless, the Sheets API approach is the right solution for many use cases: for example, dumping data into Google Sheets for reporting purposes or using Google Sheets as a database in your Python program. This can be a relatively painful process, especially if you’re new to Google’s Cloud Console.

All these packages talk from Python to Google Sheets and require you to create a Google Cloud Platform project, download a credentials file, and potentially share your spreadsheet with the user from the credentials file.

It’s been possible to automate Google Sheets via the Google Sheets API for many years and there are multiple Python packages available that wrap this API: there’s gspread, pygsheets, ezsheets, and Google’s own google-api-python-client.

How to use google drive apps script for spreadsheets