Google Apps Script - External API to Sheets

I need a Google Apps Script that reads out the data from this API into a google sheets spreadsheet:

[login to view URL]

The API is well documented there. The authentication used by the API needs to be send in the HTML header and incl. a nonce which must by dynamic (timebased).

This is the data call I need:


And this is the data I want in my google spread sheet (for all coins available under the getGains request)

[BTC] => Array


[coin] => BTC

[amount] => 1.78089028

[cost_per_unit] => 2291.86172749

[current_price] => 3308.66

[change_percent] => 44.37

[cost] => 4081.55

[current_value] => 5892.36

[unrealized] => 1810.81

[realized] => 173072.97


And this is how the data should be put into the sheet

coin amount cost_per_unit …

BTC 1.78089028 2291.86172749 …

I would need a refresh button to manually call new API data

I need an custom menu within my google sheets menu to open the script via a pulldown on any sheet.

Should coins/data -arrays be added in the API-Data-List the next run of the script should also add those new coins/data-arrays to the sheet automatically. If coins/data-arrays aren´t available any more from the API they should NOT be deleted from the sheet.

Please tell me how much that will cost me overall and how quickly you can code it after I´m giving you a GO.

I will give you a test key and secret after we came to an agreement on your proposal.

Skills: Google App Engine

See more: google apps script oauth2, google apps script dopost, google apps script json example, google apps script http request, urlfetchapp headers, google sheets parse json, google apps script rest api, google apps script curl, i am looking for someone to write a google apps script in google sheets, google apps script for sheets, google apps script attachments forward, google apps script api, google apps script validation, google apps script email validation, email validation google apps script, google apps script smtp, google apps script email verification, google apps shared contact api application, application google apps shared contacts api, google apps shared users api

About the Employer:
( 1 review ) Hamburg, Germany

Project ID: #16267879

5 freelancers are bidding on average €159 for this job


Hi I have more than 2 years of experience working in google spreadsheet and API. Currently I am working in TCS, I am an expert in Google spreadsheet and Google apps script , I have done this kind of project in past More

€55 EUR in 1 day
(3 Reviews)

I have knowledge of google script engine and I can make this code for you. Message me so that we can discuss this in detail, I can help you do this easily Regards Huzefa

€147 EUR in 3 days
(2 Reviews)

Hi. I'm a professional developer with a lot of experience in different APIs. Please contact me over chat to discuss more. Best regards.

€250 EUR in 3 days
(0 Reviews)

A proposal has not yet been provided

€144 EUR in 6 days
(0 Reviews)

I have worked on projects on hobby basis and to help friends. This will be my first project as a freelancer, so I will put my blood and sweat.

€200 EUR in 6 days
(0 Reviews)