Skip to main content

Formulas

Lido extends the standard spreadsheet formula language with powerful Lido-specific formulas for messaging, AI, file management, HTTP requests, JSON manipulation, scripting, and more.

Action vs. Non-Action Formulas​

Lido formulas fall into two categories:

  • Action formulas — Return an Action value that executes when triggered (manually or on a schedule). When not triggered, the cell displays the formula text. Examples: SENDGMAIL, COPYFILE, UPDATECELL.
  • Non-action formulas — Execute immediately during formula evaluation and return a computed value. Examples: JQ, QUERYTABLE, EVALJS.

See Actions for more on how action formulas work and how to trigger them.

Categories​

  • Messaging & Communication — Send emails, Slack messages, and SMS
  • AI & LLM — Call GPT, Claude, Gemini, and extract structured data with AI
  • Documents & PDFs — Create documents, combine PDFs, extract text, OCR
  • File Management — Copy, rename, and delete files in cloud storage
  • Export & Import — Export worksheets to Excel/CSV, import from Google Sheets
  • Calendar — Create events in Google Calendar and Outlook
  • Spreadsheet Manipulation — Update cells, insert/delete rows and columns, clear sheets
  • HTTP & Integrations — Make HTTP requests, run SQL queries
  • JSON — Create, query, transform, and parse JSON data
  • Data Querying — Query Lido tables using SQL with QUERYTABLE
  • Scripting — Run JavaScript, create lambdas, and map functions over data
  • Dashboard — Navigate dashboards, set/read component values, open URLs
  • Control Flow — Chain and batch actions, repeat, sleep, and debug
  • Text — Template strings with table column references