📨Data

This category encompasses integrations for seamless data syncing to both spreadsheets and databases, essential for maintaining up-to-date records across teams and systems. The options provided cater to various data manipulation needs including creating new records, updating existing ones, and setting specific cell values, without the requirement for coding.

Insert a New Row

This integration lets you automatically insert new rows into either a spreadsheet or database, enabling efficient data management and record-keeping. You can specify the destination and map data fields directly, streamlining the process without the need for manual coding.

Options

  • Destination:

    • For spreadsheets: Specify the Spreadsheet ID and Sheet Name you wish to connect.

    • For databases: Provide the Collection or Table Name.

  • Data to Send: Map the data fields from your source to the target column names or table fields for insertion. For spreadsheets use column names such as "A", "B". Refer to the Data Connector documentation in Actions.

Apps

Google Sheets, Airtable, Supabase, Webflow, Bubble

Update an Existing Record

This integration lets you automatically update existing rows into either a spreadsheet or database, or do nothing if no matching row is found, enabling efficient data management and record-keeping. You can specify the destination and map data fields directly, streamlining the process without the need for manual coding.

Options

  • Destination:

    • For spreadsheets: Specify the Spreadsheet ID and Sheet Name you wish to connect.

    • For databases: Provide the Collection or Table Name.

  • Conditions: Set the criteria to locate the row(s) needing updates. Refer to the Data Connector documentation in Actions.

  • Data to Send: Map the data fields from your source to the target column names or table fields to update them. For spreadsheets use column names such as "A", "B". Refer to the Data Connector documentation in Actions.

Apps

Google Sheets, Airtable, Supabase, Webflow, Bubble

Update or Insert a New Row

This integration tries to update existing rows in either a spreadsheet or database, or insert a new row if none are found, enabling efficient data management and record-keeping. You can specify the destination and map data fields directly, streamlining the process without the need for manual coding.

Options

  • Destination:

    • For spreadsheets: Specify the Spreadsheet ID and Sheet Name you wish to connect.

    • For databases: Provide the Collection or Table Name.

  • Conditions: Set the criteria to locate the row(s) needing updates. Refer to the Data Connector documentation in Actions.

  • Data to Send: Map the data fields from your source to the target column names or table fields to update them. For spreadsheets use column names such as "A", "B". Refer to the Data Connector documentation in Actions.

Apps

Google Sheets, Airtable, Supabase, Webflow, Bubble

Insert a New Timeseries Entry

This integration lets you send new timeseries entries into a specified bucket. This operation is crucial for efficiently managing and updating timeseries databases with new entries, utilizing specified tags and fields for precise data mapping.

Options

  • Measurement: Name of the bucket where to send a new timeseries entry.

  • Tag set: Map the tags for the timeseries entry. Refer to the Data Connector documentation in Actions.

  • Field set: Map the fields for the timeseries entry. Refer to the Data Connector documentation in Actions.

Apps

InfluxDB

Set the Value of a Specific Cell

Options

  • Cells and Data: Map the data fields from your monitor to the specific cells to update. Use standard spreadsheet notation such as A1, B2, C3. Refer to the Data Connector documentation in Actions.

Apps

Google Sheets


Need help?

Last updated