Answer the question
In order to leave comments, you need to log in
How to send JSON request via POST method from Google Sheet using ImportJSON script?
Good afternoon!
There is a third-party script https://github.com/bradjasper/ImportJSON that allows you to send a Json request to a site from a Gsheets cell as a formula and receive a response in the same cell.
Understanding, please tell me how to write a formula for this script in order to get a response from the site in cell A2?
Sheet:
https://docs.google.com/spreadsheets/d/1-7E7mhuP-V...
Request itself:
headers:
x-auth-token: k2sjQKT8RbNrTGZTo4ZDccxB
content-type: application/json
Body
{"data":{ "type":"link","attributes":{"short_url":"Example","web_url":" https://lenta.ru ","pixel_ids":
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question