Skip to content

Instantly share code, notes, and snippets.

View DanielR-spec's full-sized avatar
:shipit:
Focusing

Daniel Reyes DanielR-spec

:shipit:
Focusing
View GitHub Profile
(☞ ͡° ͜ʖ ͡°)☞
@DanielR-spec
DanielR-spec / importJSON.gs
Created October 11, 2023 19:34 — forked from stefanjudis/importJSON.gs
API data in google sheets
/**
* Retrieves all the rows in the active spreadsheet that contain data and logs the
* values for each row.
* For more information on using the Spreadsheet API, see
* https://developers.google.com/apps-script/service_spreadsheet
*/
function readRows() {
var sheet = SpreadsheetApp.getActiveSheet();
var rows = sheet.getDataRange();
var numRows = rows.getNumRows();