When you need to access Google Sheets data from Python script you will need to prove that you have access to the resource. There are several options to authenticate to Google API, one of them is Service Account. We will show you how to get JSON file with credentials to access Google Sheets.
How to authenticate Python to access Google Sheets with Service Account JSON credentials
October 28, 2021 by Aleksandra Płońska & Piotr Płoński Mljar Google sheets
Read Google Sheets in Python with no-code MLJAR Studio
October 26, 2021 by Aleksandra Płońska & Piotr Płoński Mljar
MLJAR Studio is a desktop application for creating Python scripts. It has a graphical user interface (GUI) for code generation. In this post we would like to show you, how to easily create a Python script for reading data from Google Sheets in Python without writing a code - code will be generated through code-forms.
MLJAR Studio a new way to build data apps
August 31, 2021 by Aleksandra Płońska & Piotr Płoński Mljar
We started to work on a new product - MLJAR Studio. It is a desktop application for the interactive development of data apps. We hope it will bring more flexibility to our users.