Google Sheets JSON API Javascript 3commas code

I need code which calls a REST API with a signed JSON payload.

Specifically, it sends a crypto currency smart trade to the online [login to view URL] service. Ultimately I want to integrate this code into Google Sheets. Therefore, the code will need to work with Javascript.

Do not apply for this job if:

1 - Do not read and understand this job fully

2 - You just copy/paste/modify a standard response

3 - Have no experience with Google Sheets, API’s or 3commas

*** PLEASE READ *** - Help me, help you by starting your response with reasons why you are a good fit for the job. Tell me about your experience with 3commas, crypto etc. I want to save your time and my own. I get dozens of replies which don't have the correct experience. I get it, I've been a freelancer. You don't want to spend much time on things at this stage and just play a numbers game and throw out responses. Please don't in this case. :)


The API’s for the 3commas service are located at [login to view URL] and [login to view URL]

My problem (the reason I’m posing this job)

I can use Postman and a SHA-256 online calculator to successfully create a simple query string. My problem comes when trying to use the

The docs at [login to view URL] show this "Another way to create smart trade v2 is send JSON body with the header”. I’ve been unable to figure out how to include a chunk of JSON which allows a Smart Trade to be created.

Request Digital Signature

Every request being sent needs to be signed using a SHA-256 algorithm. Javascript code for this is available online. In fact there are specific Google sheets examples. Here is one - [login to view URL] For testing with Postman I’ve used services like this - [login to view URL]

Skills and tools needed for this job

Experience with 3commas

Preferably a Pro account with 3commas

If you do not have a 3commas Pro account you could sign up for a free trial. No other account includes access to the API. Please be careful, the pro account is only accessible for 3 days. I will *not* pay for your account or can give you access to my own.

Good Javascript, JSON, REST API knowledge

Basic Google Sheets scripting knowledge


A working Google sheets spreadsheet which:

1 - Contains a Google worksheet for all the parameters required for a 3commas Smart Trade (see JSON example below). Includes private/secret keys.

2 - A button on the worksheet which executes Javascript code

3 - Javascript code which successfully places a Smart Trade with 3commas (paper trading account)

I will replace your private/secret with my own and should see the code run correctly.

JSON example

Here’s an example from the 3commas docs which show the type of JSON structure which needs to be passed to the service. This is a good example of what I’ll need. It contains the key elements:

1 - Account ID, pair to buy etc.

2 - The buy position amount, market order type

3 - Take profit

4 - Stop loss

You will need to put all these parameters into a Google sheet and then use Javascript code to pull the parameters from the sheet and use them in Javascript code to call the 3commas Smart Trade service.


Kemahiran: JSON, Google Sheets, API, JavaScript, Trading

Lihat lagi: calculate distance google maps java api javascript, google sheets maps api, google sheets external api, google sheets rest api, google sheets zillow api, google sheets instagram api, google sheets facebook api, google analytics reporting api javascript, google sheets script api, google sheets weather api, google sheets rest api example, google ad manager api javascript, google sheets sms api, google sheets amazon api, google sheets post api, google sheets json object, google sheets json parse, google sheets shopify api, google sheets web scraping javascript, google sheets linkedin api

Tentang Majikan:
( 149 ulasan ) London, United Kingdom

ID Projek: #31556820

Dianugerahkan kepada:


Hi! I'll be honest with you, I don't have experience in Google Sheets specifically, but it's standard JS, so shouldn't be a problem. I also don't have experience with 3commas (kind of a specific thing to ask on this si Lagi

$110 USD dalam 4 hari
(0 Ulasan)

5 pekerja bebas membida secara purata $140 untuk pekerjaan ini


⭐️Hi There⭐️ I am confident for the project ⭐️GUARANTEE:- WORK DONE OR FULL REFUND ⭐️WHY ME :- I have 100% complete rate because I have good Respect for clients and i always try to make good communication to clear th Lagi

$170 USD dalam 5 hari
(7 Ulasan)

Hi, I'm a full-stack web developer with over 8 years of experience. I saw your article and have a few concerns about your project. I'd be happy to talk more about it. Gratitude!

$140 USD dalam sehari
(0 Ulasan)

As a web developer, my skill is perfect in your job Google Sheets JSON API Javascript 3commas code .. I have Skills in PHP, WordPress(CMS), HTML5, CSS3, JavaScript, jQuery, Bootstrap, PSD to HTML, Website design HTML, Lagi

$140 USD dalam 7 hari
(0 Ulasan)

Hi, Just read your posting. Sounds like you need an expert Web developer who can help you make the perfect web application for you and I can assist you in this situation. In addition to my development skills I also ha Lagi

$140 USD dalam 7 hari
(0 Ulasan)