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.