Connect Google Sheet with Coingecko API

Job Description:
We are looking for an experienced developer who can connect the CoinGecko API to a Google Sheet in order to automatically pull live cryptocurrency data.

Scope of Work:

• Connect our Google Sheet with the CoinGecko API.
• Retrieve the following data for multiple assets:
  • Current price
  • Market cap
  • All-time high (ATH)
  • All-time low (ATL)
• Ensure that whenever we add a new ticker symbol to the sheet, the corresponding data is fetched automatically.
• Set up an automatic refresh/update every 10 minutes.
• We will provide access to our CoinGecko account.

Requirements:

• Strong experience with Google Apps Script and APIs.
• Familiarity with CoinGecko API (or similar crypto APIs).
• Ability to deliver a clean, efficient, and easy-to-use solution.

Deliverable:
A Google Sheet that dynamically pulls and updates crypto market data from CoinGecko without requiring manual intervention.