Useful tricks in Google Sheets

README.md

Useful tricks in Google Sheets

Formulas

Generate ID

=ArrayFormula(
  if(
    len(A2:A),
    sequence(match(2,1/(LEN(A2:A) > 0),1),1),
    ""
  )
)

Custom formulas

Fetch data

// The Google Sheets user can type `=FETCH('https://example.com')` into a cell to fetch their data
async function FETCH (url) {
  const response = await UrlFetchApp.fetch(url),
        responseText = await response.getContentText(),
        responseJson = JSON.parse(responseText)
  
  // Return something to display in the Google Sheet.
}