Creating a service account for access to GOOGLE spreadsheets

Next, we will enable the Google Cloud services API

Type Sheets into the search and select Google Sheets API

In the example in the screenshot, it is already enabled

We go back to search and enter Google Drive.
We select it as shown in the screenshot.
Also enable it; the steps are no different from Google Sheets.

All steps are repeated.

If you go to the "APIs & Services" tab from the project page,
you should see the result as in the screenshot.

Which half, you ask?

Yes, the creation process is quite complex, and avoiding mistakes is even more difficult!

Next, we move to the Credentials (Access, access credentials) tab

We create a new one and select a service account!

The names do not matter at this stage.

Be sure to choose as shown in the screenshot.

In general, you must grant all permissions.

Why all, you ask? Because we won’t be able to explain and sort through the 1,500 types of Google permissions in this article!

If you choose the one I selected in the screenshot, an error may appear if you already have a user with those permissions. In that case, use the one that has already been created.