Connect Grist and Pennylane

Both apps 64Grist 25Pennylane 39

• Trigger
  New or Updated Record

  Triggered when a row in a Grist table is created or updated.

• Trigger
  New or Updated Record (Instant)

  Triggers when a Record is updated, or a new Record is added.

• Trigger
  New Record

  Triggered when a new row is added to a Grist table.

• Trigger
  New Record (Instant)

  Triggers when a new Record is created

• Action
  Add Column

  Adds a column to a table in a Grist document.

• Action
  Add Table

  Creates a new table in a Grist document, optionally with a starting set of columns.

• Action
  Create Document

  Creates a new document in a Grist workspace and returns its document ID.

• Action
  Create or Update Record

  Adds a row to a Grist table, or updates the existing row when the match column already holds the match value. Returns the row ID.

• Action
  Create Record

  Adds a new row to a Grist table and returns its row ID.

• Action
  Create Workspace

  Creates a new workspace in a Grist organization and returns its ID.

• Action
  Delete Document

  Deletes a Grist document permanently.

• Action
  Delete Records

  Deletes one or more rows from a Grist table by row ID.

• Action
  Delete Workspace

  Deletes a Grist workspace along with every document inside it.

• Action
  Find Record

  Searches a Grist table for a row whose column holds a given value and returns that row's ID and column values.

• Action
  Get Document

  Returns the details of one Grist document — its name, web address, workspace, and organization.

• Action
  Get Org

  Returns the details of one Grist organization (team site) — its name, subdomain, owner, and your access level.

• Action
  Get Workspace

  Returns the details of one Grist workspace, including the documents it contains.

• Action
  List Columns

  Returns the columns of a Grist table, with each column's ID, label, and type.

• Action
  List Orgs

  Returns every Grist organization (team site) this connection can reach.

• Action
  List Tables

  Returns the tables in a Grist document.

• Action
  List Workspaces

  Returns the workspaces in a Grist organization, each with the documents it contains.

• Action
  Run SQL Query

  Runs a read-only SELECT statement against a Grist document and returns the rows.

• Action
  Update Document

  Renames a Grist document or changes whether it is pinned. Anything left blank stays as it is.

• Action
  Update Record

  Changes the column values of one row in a Grist table. Columns left blank keep their current values.

• Action
  Update Workspace

  Renames a Grist workspace.

• Trigger
  New Billing Subscription V2

  Triggers when a new billing subscription is created in Pennylane.

• Trigger
  New Customer Invoice V2

  Triggers when a new customer invoice or credit note is created in Pennylane.

• Trigger
  New Customer V2

  Triggers when a new customer (company or individual) is created in Pennylane.

• Trigger
  New Product V2

  Triggers when a new product is created in Pennylane.

• Trigger
  New Quote V2

  Triggers when a new quote is created in Pennylane.

• Action
  Add supplier

  Creates a supplier in Pennylane and returns the new supplier record.

• Action
  Create Company Customer V2

  Creates a company customer in Pennylane with its billing address, contact and invoicing details, and returns the new customer.

• Action
  Create Customer Invoice V2

  Creates a draft or finalized customer invoice (or credit note) in Pennylane for an existing customer.

• Action
  Create Individual Customer V2

  Creates an individual (person) customer in Pennylane with their name, billing address and invoicing preferences.

• Action
  Create Product V2

  Creates a product in Pennylane with its label, price before tax and VAT rate, and returns the created product.

• Action
  Create Quote V2

  Creates a quote for a customer in Pennylane, with its line items, dates and optional discount.

• Action
  Finalize customer invoice

  Finalizes a draft customer invoice or credit note in Pennylane, assigning its number and locking it from further edits.

• Action
  Get Billing Subscription V2

  Returns one billing subscription, including its schedule, status, customer and invoice settings.

• Action
  Get supplier

  Returns a single supplier from Pennylane by its id, including contact, address, payment terms and ledger account.

• Action
  Get supplier invoice

  Returns a single supplier invoice from Pennylane by its ID, including amounts, dates, supplier, and payment status.

• Action
  Get transaction

  Returns a single bank transaction by its id, including amount, currency, date, bank account, categories and linked customer or supplier.

• Action
  List bank accounts

  Returns the company's bank accounts with their currency, balance, journal and ledger account.

• Action
  List billing subscriptions

  Returns the billing subscriptions in the Pennylane company, optionally filtered by status, customer or start date.

• Action
  List categories

  Returns the analytical categories defined in the Pennylane company, optionally filtered by group, label or code.

• Action
  List customer invoices

  Returns customer invoices and credit notes, optionally filtered and sorted.

• Action
  List customers

  Returns a list of company and individual customers in Pennylane, optionally filtered and sorted.

• Action
  List ledger accounts

  Returns the company's ledger accounts (chart of accounts), up to 1000 per call, optionally filtered by number, id or enabled status.

• Action
  List ledger entries

  Returns the ledger entries of your Pennylane company, optionally filtered by id, date or journal and sorted by id or date.

• Action
  List products

  Returns the products in the Pennylane company, optionally filtered by label, reference or id.

• Action
  List quotes

  Returns the quotes in your Pennylane company, optionally filtered by customer or status.

• Action
  List supplier invoices

  Returns the supplier invoices in your Pennylane company, optionally filtered and sorted.

• Action
  List suppliers

  Returns the suppliers in your Pennylane company, optionally filtered and sorted.

• Action
  List transactions

  Returns the bank transactions in your Pennylane company, optionally filtered by bank account, journal, date or id.

• Action
  Retrieve Customer V2

  Returns one customer (company or individual) by its Pennylane id, including contact details, addresses and billing settings.

• Action
  Retrieve Invoice V2

  Returns one customer invoice or credit note, including its amounts, status, customer and links to its lines and payments.

• Action
  Retrieve Product V2

  Returns one Pennylane product by its id, including price, VAT rate, unit, ledger account and custom field values.

• Action
  Retrieve Quote V2

  Returns a single quote by its ID, including amounts, status, customer and dates.

• Action
  Update Billing Subscription V2

  Updates a billing subscription in Pennylane: stop or resume it, change its invoicing mode, payment terms, schedule, customer or invoice content.

• Action
  Update Company Customer V2

  Updates an existing company customer in Pennylane and returns the updated customer.

• Action
  Update customer invoice

  Updates a customer invoice in Pennylane. Draft invoices accept all fields; finalized invoices accept only label, external reference, transaction reference, invoice line imputation/performance dates and installments.

• Action
  Update Individual Customer V2

  Updates an individual (person) customer in Pennylane and returns the updated customer.

• Action
  Update Product V2

  Updates an existing product in Pennylane, such as its label, price, VAT rate or custom fields.

• Action
  Update Quote V2

  Updates an existing quote in Pennylane — its dates, customer, texts, discount, language and invoice lines — and returns the updated quote.

• Action
  Update supplier

  Updates an existing supplier in Pennylane and returns the updated supplier.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.