Google Sheets

Loopfour can read and write the Google Sheets your team keeps working schedules in, such as an accruals tracker or a list of open items.

What you can do

• Read a sheet: read the cells in a range, such as Accruals!A1:F200, or several ranges at once.
• Add rows: append rows to the end of a table, or insert one row at a set position.
• Update or add one row: find the row whose key matches, such as an invoice number, and overwrite it, or add it when there is no match.
• Overwrite or clear cells: write new values over a range, or clear a range and keep its formatting.
• Manage spreadsheets and tabs: create a spreadsheet, add, copy or delete a tab, and insert a column.

Connect Google Sheets

You sign in with the Google account that can edit the spreadsheets.

Loopfour can reach the spreadsheets that Google account can edit.

Good to know

• Ranges use the sheet's own addresses. Put the tab name in quotes when it has a space, such as 'Q3 Data'!A1:C10.
• Values go in as typed. By default Loopfour writes values exactly as given. Choose USER_ENTERED in Value Input Option when Google should read dates, numbers or formulas.
• Add many rows in one step. Append Values takes many rows at once. Google limits how many writes a user can make per minute, so one larger step is safer than many small ones.
• Some steps cannot be undone. Delete Sheet, the clear steps and Batch Update Spreadsheet change the file for good. Keep a copy of important schedules.
• Google Sheets does not start workflows. Run the workflow on a schedule or from another system's event.

Choose a finance job

Browse Finance playbooks for patterns to adapt. Check this page's supported jobs before substituting this system for one named in a playbook. For a different job, describe the workflow in chat.