
How to connect Bots to sheets
By Bumi
In this guide, we'll learn how to access and update a Google Sheets file using a bot. We'll explore how to navigate the remote instance to locate and open the necessary files, such as update_sheets.py
and credentials.json
. Additionally, we'll cover how to share access to the Google Sheets file with the bot to enable updates.
Let's get started
Open the remote instance.
1
Click here

Go to the bot window you want to open and click to open the src directory.
2
Click here

3
Click on ">"

Scroll down to see the updated sheets.
4
Click on "update_sheets.py"

I'm sorry, but it seems like there is no content provided to refine. Could you please provide the text you would like me to work on?
5
Double-click on "update_sheets.py"

Open it. Here, you can see the code.
6
Click here

7
Type "Ctrl + A"
8
Click here

There are also these credentials.
9
Double-click on "credentials.json"

10
Click here

11
Type "Ctrl + A"
12
Click here

13
Click on "credentials.json X"

14
Click on "update_sheets.py x"

15
Click on "✓"

16
Click on "- Googl"

Go to the sheets and share access with this bot.
17
Click on "Share"

18
Click on "Done"

Done.