Q: why do i get rate limits error when i query Binance API via Google Sheets?
A: Google Sheet sends all requests from a pool of IP addresses which is shared among all users on Google. Therefore, it is highly likely that the IP address you are assigned has met the rate limit from Binance API.
A solution that you may consider is to:
1.Send the request from your local machine or your server
2.Get the relevant data
3.Upload it to your google sheet via the Google Sheet API (https://developers.google.com/sheets/api/quickstart/quickstarts-overview).