How to install it in Google Sheet?

[winzou]

Hello,

I'm confused about how to copy/paste the content of CoinGecko.gs.
I've tried to paste it in the "Script Editor" of my spreadsheet, but it does not compile and outputs some errors.

Thanks for your insights

[Eloise1988]

Check if you have authorized Google Services 
Apps Script requires user authorization to access private data from built-in Google services or advanced Google services.

[winzou]

Thanks for your anwser. I managed to make it work by removing all await and async keywords from the code. Was it supposed to work with these keywords? Weird.

[Eloise1988]

Strange.
It works also without await and async but it will give more errors.
If you want to see how a template of the how the CoinGecko functions work, you can duplicate the following sheet and check the code:
https://docs.google.com/spreadsheets/d/1QODede4loYFnd9ig_f4vRiO4J4uptxn8zIx3qRsLDeA/edit?usp=sharing

I've explained the CoinGecko functionalities in the following medium:
https://medium.com/the-cryptocurious/coingecko-prices-volumes-market-caps-in-google-sheets-and-excel-a1a3ee201cb8

[CueCueWhee]

I am facing issues with async also. I ported your code fully over, and syntax error still get throw out.