Icon

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
Step #1: Click here

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

2
Click here
Step #2: Click here
3
Click on ">"
Step #3: Click on ">"

Scroll down to see the updated sheets.

4
Click on "update_sheets.py"
Step #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"
Step #5: Double-click on "update_sheets.py"

Open it. Here, you can see the code.

6
Click here
Step #6: Click here
7
Type "Ctrl + A"
8
Click here
Step #8: Click here

There are also these credentials.

9
Double-click on "credentials.json"
Step #9: Double-click on "credentials.json"
10
Click here
Step #10: Click here
11
Type "Ctrl + A"
12
Click here
Step #12: Click here
13
Click on "credentials.json X"
Step #13: Click on "credentials.json X"
14
Click on "update_sheets.py x"
Step #14: Click on "update_sheets.py x"
15
Click on "✓"
Step #15: Click on "✓"
16
Click on "- Googl"
Step #16: Click on "- Googl"

Go to the sheets and share access with this bot.

17
Click on "Share"
Step #17: Click on "Share"
18
Click on "Done"
Step #18: Click on "Done"

Done.