Click the export button on the top right of the table. Then select Google Sheets and select how many rows you want to export. Click "Generate API" to get your customized API to the data.
After generating API, the API will be automatically copied to your clipboard. All you need to do is tp paste it (Ctrl+V for Windows or Command+V for Mac) into Google Sheets later.
Open a tab in Google Sheets. Type =IMPORTDATA(). Then paste your API endpoints inside of the brackets with quotes.
Don't forget to quote your API in the parentheses.
Your function should look like: =IMPORTDATA("https://api.acho.io/project/export-data/googlesheets/xxxxxxxxxxxxxxxxxxxxx")
If you encountered the following error. Please try to export fewer rows. Google Sheets has a limit for total cells. The number of rows you can import depends on how many columns you have.