Introducing SIP in any token via Google Sheets API | Bitbns

Dear User,

Bitbns has API trading functionality using a number of popular libraries like Node, Python etc. We are now extending this to Google Sheets, which allows users to do API trading without running any servers and without having in depth coding knowledge. To get things started, the library is bundled with a sample SIP application. Users can create and delete SIPs on any Bitbns listed token using this app. Please note this is independent of SIPs being done on bitdroplet.

Please follow these steps to get started —

1. Create API Key in Bitbns account

2. Make a copy of the sample google sheet using file->Make a Copy

3. Enter the API key and secret from bitbns site in the config sheet of the google sheet

4. Go to Add-ons, select Bitbns-Google-Sheets-API and select “Bitbns SIP”

5. Allow the script to run and give script permission to run

This opens a gmail oauth window. Please make sure you choose the primary(default) gmail/google apps account there as the google sheets project uses primary account for API functions(if you want to use some other account, please open the sheet in an incognito tab and login with the account to be used)

6. Add SIP

After giving permissions, go to Add-ons->Bitbns-Google-Sheets-API and click on Bitbns SIP again. This will open a form on the right. Fill in the details(select token, SIP Frequency and Amount) and click Bitbns SIP button there. The SIP details will be inserted in the “SIP” sheet and trigger will be added to place sip order at the desired time on recurring basis.

7. Delete SIP

To remove a SIP, copy the trigger ID of the SIP from SIP sheet, paste it in the delete SIP form and click the “Delete SIP” button(see above). Please don’t modify or delete the trigger Id directly in the spreadsheet.

8. Further development

To open the code associated with the add-on and to make any changes, please open the associated Google Appscript Project by going to tools->Script Editor. This will open the google app script project associated with the add-on.

Code details can be found in the github repo for this project.

9. Tracking and troubleshooting

Triggers added by the add-on and their execution can be tracked in the google app script project(see above on how to go there). In case of issues, there is a function called “deleteAllSip” which can be run to delete all SIP triggers present in the function.

10. Best practices

• Make sure that no third party apps have read permission on the Google drive account having this spreadsheet, to prevent them reading API Keys. This can be checked in Google Drive under Settings->Manage Apps
• Do not share API Keys with anyone including people in api support group. Please don’t post screenshots etc with API Key/Secret visible
• Please remember at all times that API Key/Secret combination can be used to place orders in your Bitbns account

For any help, please join the https://telega.one/bitbns_api_support group.

For reporting any issues, please use this page and add a new issue.

Happy Trading,

Bitbns Team