📨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
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
Need help?
❓Common questions (FAQ)⛑️Troubleshooting🚁SupportLast updated