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.

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.

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.