All integrationsSpreadsheets

Google Sheets

Read and write rows in Google Sheets workbooks.

actions
18
trigger
1

Triggers

Start a workflow when something happens in Google Sheets.

  • Google Sheets New RowTriggers when a new row is added to a Google Sheets spreadsheet.

Actions

Steps a workflow can run in Google Sheets.

  • Append rowAppend a single row to the end of a Google Sheet.
  • Create spreadsheetCreate a new Google Sheets spreadsheet.
  • Delete spreadsheetDelete a Google Sheets spreadsheet permanently.
  • Write rowOverwrite a whole row, from column A, with values in column order. To change only some cells of a row, use Update row.
  • Update rowSet some cells of one row by column name, leaving the rest of the row as it is. Pair it with Read rows to write a result back to the row it came from. A column that doesn't exist yet is added to the header row.
  • Clear row valuesClear values in a specific row without deleting the row itself.
  • Read rowsRead every data row of a sheet at once. Each row comes back as an object keyed by the column headers (row.Email), plus the sheet row number, so Update row can write a result back to that exact row. Use this to loop over a list of records.
  • Read columnRead all values from a specific column.
  • Get row valuesReturn all values from a specific row as a list.
  • Get column valuesReturn all values from a specific column, chosen by its position number.
  • Create tabCreate a new tab (sheet) within a spreadsheet.
  • Delete tabDelete a tab (sheet) from a spreadsheet by name.
  • Rename tabRename an existing tab in a spreadsheet.
  • Append cell to columnAppend a single value to the end of a column.
  • Clear tabClear all cells within a sheet/tab.
  • Delete rowDelete a single row from a sheet.
  • Delete columnDelete a single column from a sheet.
  • Create columnInsert a new column at a specified position.

Templates that use Google Sheets

See all 93

Never miss a filing or renewal deadline

Checks your deadline sheet each morning and emails you as each licence, permit, tax filing or renewal comes due, with a calendar event.

Find matching rows in a spreadsheet

Every hour, finds the rows on a Google Sheets tab where a column holds a value you choose, or is empty, ready for the steps you add.

Email last month's profit and loss for each department

On the 3rd of each month, emails you last month's profit and loss for each department, or for the whole business, with AI commentary.

Identify who was paid on every bank feed line

Researches each new line on a client's bank feed sheet and writes who was paid, what they do and where to post it, with sources.

Drip helpful articles to your leads

Every day, emails the next few leads in your sheet a random article with a short AI note, and comes back to each after a set gap.

Weekly revenue up-or-down email

Every Monday, totals last week's revenue from your sheet, says if it is up or down on the week before, and explains a rise.

Automate Google Sheets with Lodol.

Connect Google Sheets and ask your AI for your first workflow.

Free plan, no credit card