How to add data from a third-party site to Google Spreadsheet?

S

S

Seeker0012019-05-19 18:30:43

API

Seeker001, 2019-05-19 18:30:43

How to add data from a third-party site to Google Spreadsheet?

How to add the value of the exchange rate of bitcoin to the ruble in Google spreadsheet?
https://api.coinmarketcap.com/v1/ticker/bitcoin/?c...
value "price_rub"

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

N

Noir, 2019-05-19
@PolarBearGG

=importxml("https://api.coinmarketcap.com/v1/ticker/bitcoin/?convert=RUB","/")

only you need to insert a token into the link that is in your personal account on the site

Similar questions

T

TheInvisible2017-01-16 06:38:11

DLE API: Adding news via api, (POST or GET request) is there a ready-made solution, code? 0Reply

I

Ivan Yakushenko2019-06-09 16:09:42

Why isn't more than one button created with pyTelegramBotAPI? 1Reply

M

Maxim Zolotoy2019-06-10 12:48:56

How to send a JSON object to a foreign API using the GET method from JS? 2Reply

A

Adam2021-01-31 16:39:20

Telethon Telegram api How to add to contacts without phone number? 1Reply

M

miks20202019-06-13 18:58:17

How to iterate api in React component? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question