Connect Smartsheet via API Token to Lexware Office

Both apps 153Smartsheet via API Token 103Lexware Office 50

• Trigger
  List contacts

  List contacts

• Trigger
  List dashboards

  List dashboards

• Trigger
  List org groups

  List org groups

• Trigger
  List reports

  List reports

• Trigger
  List sheets

  List sheets

• Trigger
  List workspaces

  List workspaces

• Trigger
  New favorite

  Triggers when a new item is added to your favorites.

• Trigger
  New row

  Polling trigger: fires when a new row is added to the specified sheet. Each row carries a stable id for deduplication.

• Trigger
  New search result

  Triggers when a new item matches your search query.

• Action
  Add columns

  Add columns

• Action
  Add favorites

  Add favorites

• Action
  Add image to cell

  Add image to cell

• Action
  Add rows

  Add one or more rows to a sheet. Provide an array of row objects with cells.

• Action
  Add summary fields

  Add summary fields

• Action
  Attach file or URL to comment

  Attach file or URL to comment

• Action
  Attach file or URL to row

  Attach file or URL to row

• Action
  Attach file or URL to sheet

  Attach file or URL to sheet

• Action
  Attach new version

  Attach new version

• Action
  Copy folder

  Copy folder

• Action
  Copy rows to another sheet

  Copy rows to another sheet

• Action
  Copy sheet

  Copy sheet

• Action
  Copy workspace

  Copy workspace

• Action
  Create a comment

  Create a comment

• Action
  Create a discussion on a row

  Create a discussion on a row

• Action
  Create an update request

  Create an update request

• Action
  Create cross-sheet references

  Create cross-sheet references

• Action
  Create discussion

  Create discussion

• Action
  Create folder

  Create a folder in the user's Home.

• Action
  Create folder in workspace

  Create folder in workspace

• Action
  Create proof

  Create proof

• Action
  Create proof discussion

  Create proof discussion

• Action
  Create proof request

  Create proof request

• Action
  Create sheet

  Creates a new sheet with the given name and columns in the user's home "Sheets" area. To create a sheet inside a specific folder or workspace, use Create sheet in folder or Create sheet in workspace.

• Action
  Create sheet in folder

  Create sheet in folder

• Action
  Create sheet in workspace

  Create sheet in workspace

• Action
  Create workspace

  Create workspace

• Action
  Delete a comment

  Delete a comment

• Action
  Delete a discussion

  Delete a discussion

• Action
  Delete an update request

  Delete an update request

• Action
  Delete attachment

  Delete attachment

• Action
  Delete column

  Delete column

• Action
  Delete favorites

  Removes one or more objects of a given type from the user's Smartsheet favorites. Accepts a single object ID or a comma-separated list.

• Action
  Delete folder

  Delete folder

• Action
  Delete report

  Delete report

• Action
  Delete rows

  Delete rows

• Action
  Delete sent update request

  Delete sent update request

• Action
  Delete sheet

  Delete a sheet by id.

• Action
  Delete summary fields

  Delete summary fields

• Action
  Delete workspace

  Delete workspace

• Action
  Edit a comment

  Edit a comment

• Action
  Get a comment

  Get a comment

• Action
  Get an update request

  Get an update request

• Action
  Get attachment

  Get attachment

• Action
  Get column

  Get column

• Action
  Get contact

  Get contact

• Action
  Get cross-sheet reference

  Get cross-sheet reference

• Action
  Get discussion

  Get discussion

• Action
  Get folder metadata

  Get folder metadata

• Action
  Get proof

  Get proof

• Action
  Get report

  Get report

• Action
  Get row

  Get a single row from a sheet by row id.

• Action
  Get sent update request

  Get sent update request

• Action
  Get sheet

  Get a sheet by id, including its rows and columns.

• Action
  Get sheet summary

  Get sheet summary

• Action
  Get summary fields

  Get summary fields

• Action
  Get user

  Get user

• Action
  Get workspace

  Retrieves a Smartsheet workspace by ID, including its sheets, folders, reports, sights, templates, permalink, and access level.

• Action
  Is favorite

  Is favorite

• Action
  List attachments

  List attachments

• Action
  List columns

  List all columns of a sheet.

• Action
  List contents

  List contents

• Action
  List cross-sheet references

  List cross-sheet references

• Action
  List discussion attachments

  List discussion attachments

• Action
  List discussions

  List discussions

• Action
  List discussions with a row

  List discussions with a row

• Action
  List folder children

  List folder children

• Action
  List folders

  List the folders in the user's Home.

• Action
  List proof attachments

  List proof attachments

• Action
  List proofs

  List proofs

• Action
  List row attachments

  List row attachments

• Action
  List sheet rows

  Convenience read: returns the rows of a sheet (the full sheet object with rows and columns).

• Action
  List sheets

  List all sheets the user has access to.

• Action
  Lists sent update requests

  Lists sent update requests

• Action
  List update requests

  List update requests

• Action
  List workspace children

  List workspace children

• Action
  List workspaces

  List all workspaces the user has access to.

• Action
  Move folder

  Move folder

• Action
  Move rows to another sheet

  Move rows to another sheet

• Action
  Move sheet

  Move sheet

• Action
  Search

  Search across all sheets the user can access for the given text.

• Action
  Search sheet

  Search a specific sheet for the given text.

• Action
  Send report via email

  Send report via email

• Action
  Send rows via email

  Send rows via email

• Action
  Send sheet via email

  Send sheet via email

• Action
  Sort rows in sheet

  Sort rows in sheet

• Action
  Update an update request

  Update an update request

• Action
  Update column

  Update column

• Action
  Update folder

  Update folder

• Action
  Update proof status

  Update proof status

• Action
  Update rows

  Update one or more existing rows in a sheet. Provide an array of row objects each with an id and cells.

• Action
  Update sheet

  Update sheet

• Action
  Update summary fields

  Update summary fields

• Action
  Update workspace

  Update workspace

• Trigger
  Contact updated (instant)

  Fires when a contact changes in Lexware Office. Event type: contact.changed.

• Trigger
  Invoice status changed (instant)

  Fires when an invoice's status changes in Lexware Office. Event type: invoice.status.changed.

• Trigger
  New article (instant)

  Fires when a new article is created in Lexware Office. Event type: article.created.

• Trigger
  New contact (instant)

  Fires when a new contact is created in Lexware Office. Event type: contact.created.

• Trigger
  New credit note (instant)

  Fires when a new credit note is created in Lexware Office. Event type: credit-note.created.

• Trigger
  New invoice (instant)

  Fires when a new invoice is created in Lexware Office. Event type: invoice.created.

• Trigger
  New order confirmation (instant)

  Fires when a new order confirmation is created in Lexware Office. Event type: order-confirmation.created.

• Trigger
  New quotation (instant)

  Fires when a new quotation is created in Lexware Office. Event type: quotation.created.

• Trigger
  New voucher (instant)

  Fires when a new bookkeeping voucher is created in Lexware Office. Event type: voucher.created.

• Trigger
  Payment changed (instant)

  Fires when the payment status of a sales voucher changes in Lexware Office. Event type: payment.changed.

• Action
  Create a contact

  Creates a contact in Lexware Office as a person or a company, with optional billing address, email, phone and note, and returns the new contact's ID.

• Action
  Create a credit note

  Creates a credit note in Lexware Office for an existing contact or a typed-in address, with your line items. Saves it as a draft unless you choose to finalize it.

• Action
  Create a delivery note

  Creates a delivery note in Lexware Office for an existing contact or a typed-in address, with your delivered line items. Saves it as a draft unless you choose to finalize it.

• Action
  Create a dunning

  Creates a dunning (payment reminder) in Lexware Office, normally chasing an unpaid invoice. Saves it as a draft unless you choose to finalize it.

• Action
  Create an article

  Creates a product or service article in Lexware Office with its unit, price and tax rate, and returns the new article's ID.

• Action
  Create an invoice

  Creates an invoice in Lexware Office for an existing contact or a typed-in address, with your line items and payment terms. Saves it as a draft unless you choose to finalize it.

• Action
  Create an order confirmation

  Creates an order confirmation in Lexware Office for an existing contact or a typed-in address, with your confirmed line items. Saves it as a draft unless you choose to finalize it.

• Action
  Create a quotation

  Creates a quotation in Lexware Office for an existing contact or a typed-in address, with your quoted line items and an expiry date. Saves it as a draft unless you choose to finalize it.

• Action
  Create a voucher

  Books a voucher (an incoming or outgoing document) into Lexware Office with its booking lines, and returns the new voucher's ID.

• Action
  Delete an article

  Deletes an article from Lexware Office by its ID.

• Action
  Download a credit note file

  Returns the PDF file ID and download URL for a finalized credit note in Lexware Office.

• Action
  Download a delivery note file

  Returns the PDF file ID and download URL for a finalized delivery note in Lexware Office.

• Action
  Download a dunning file

  Returns the PDF file ID and download URL for a finalized dunning in Lexware Office.

• Action
  Download a file

  Downloads the actual bytes of a file stored in Lexware Office by its file ID — for example the PDF that "Download an invoice file" reports. Returns the file so a later step can email, upload or attach it.

• Action
  Download an invoice file

  Returns the PDF file ID and download URL for a finalized invoice in Lexware Office.

• Action
  Download an order confirmation file

  Returns the PDF file ID and download URL for a finalized order confirmation in Lexware Office.

• Action
  Download a quotation file

  Returns the PDF file ID and download URL for a finalized quotation in Lexware Office.

• Action
  Find articles

  Searches the Lexware Office article list by article number, barcode or type, and returns the matching articles a page at a time.

• Action
  Find contacts

  Searches Lexware Office contacts by email, name, number or role, and returns the matching contacts a page at a time.

• Action
  Find voucher list

  Lists Lexware Office documents (invoices, credit notes, quotations and the rest) filtered by type, status, contact and date, a page at a time.

• Action
  Find vouchers

  Finds booked vouchers in Lexware Office by their document number and returns the full voucher records.

• Action
  Get a contact

  Returns one Lexware Office contact by its ID, with its roles, person or company details, addresses, emails and phone numbers.

• Action
  Get a credit note

  Returns one Lexware Office credit note by its ID, with its recipient, line items, totals and status.

• Action
  Get a delivery note

  Returns one Lexware Office delivery note by its ID, with its recipient, delivered lines and delivery date.

• Action
  Get a dunning

  Returns a single dunning (payment reminder) by its ID, including its addressee, line items, totals and PDF file reference.

• Action
  Get an article

  Returns a single article (product or service) by its ID, including its name, article number, unit and pricing.

• Action
  Get an invoice

  Returns a single invoice by its ID, including its addressee, line items, totals, payment terms and PDF file reference.

• Action
  Get an order confirmation

  Returns a single order confirmation by its ID, including its addressee, line items, totals and PDF file reference.

• Action
  Get a quotation

  Returns a single quotation by its ID, including its addressee, line items, totals, expiry date and PDF file reference.

• Action
  Get a voucher

  Returns a single bookkeeping voucher by its ID, including its type, contact, amounts, line items and attached files.

• Action
  Get payment information

  Returns the payment status of a voucher, such as an invoice: how much is still open, when it was paid, and the individual payments booked against it.

• Action
  Pursue to a credit note

  Creates a credit note that follows on from an existing invoice, linking the two in Lexware Office. Copies the invoice's recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to a delivery note

  Creates a delivery note that follows on from an existing order confirmation, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to a dunning

  Creates a dunning (payment reminder) that follows on from an unpaid invoice, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to an invoice

  Creates an invoice that follows on from an existing order confirmation, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Pursue to an order confirmation

  Creates an order confirmation that follows on from an existing quotation, linking the two in Lexware Office. Copies the recipient, lines and tax settings unless you supply your own lines.

• Action
  Update a contact

  Updates an existing contact in Lexware Office. Reads the contact first and changes only the details you fill in, leaving everything else as it was.

• Action
  Update an article

  Updates an existing article in Lexware Office. Reads the article first and changes only the details you fill in, leaving everything else as it was.

• Action
  Update a voucher

  Updates an existing bookkeeping voucher in Lexware Office. Reads the voucher first and changes only the details you fill in, leaving everything else as it was.

• Action
  Upload Document for Bookkeeping Purposes

  Uploads a receipt or other document to Lexware Office for bookkeeping and returns its file ID, which you can attach to a voucher.

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