How to copy Google sheet config for a bot? - SoftFx/AlgoBots GitHub Wiki

Some Algo bots use Google Sheets to work (ex. 100YearPortfolio bot). For correct working with such a bot you need to copy and set up this Config Sheet on your Google account.

Copy Default Sheets

First of all you need to copy default config:

  1. Log in to your Google account;
  2. Open the bot file with the default configuration;
  3. Make a copy of the bot file: File -> Make a copy.

Make a copy Make a copy 2

Set up read permissions

Secondly, you need to give permission to read the sheet:

  1. Configure access to the bot file: File -> Share -> Share with others.

ShareSheet1

  1. In the General access, select Anyone with the link and the Viewer role.

ShareSheet2

How to use my sheet

Finally, you can copy this link:

SetupBot

And add the link in the bot setup:

SetupBot2