Skip to content

Instantly share code, notes, and snippets.

How to add free crypto current price fetcher to your google sheet?

1- In your google sheet open Tools menu > script editor

Screenshot 2021-05-30 at 00 18 00

2- Remove anything on the editor then paste the follwing code:

  function cryptoCoinPrice(cryptoSymbol = 'BTC', refresh) {

Dear guys,

This week I was facing this problem:

In agent zero we want to select the order along with the latest payment status and since order may have one or more payment status things was kinda tricky.

So first I write the query and select all payment status for the order like: