Integrate.io Release Notes & Product Updates

July's release cycle put AI assistance at the center of the package designer, covering pipeline building, field mapping, and expression writing. Alongside that, the editor gained safer handling of in-progress work, workflow orchestration went a level deeper, and destination coverage expanded.

Helm: Prompt to Pipeline

Helm is your copilot in Integrate.io. It builds pipelines, answers questions, and manages your packages.

• Build a pipeline from a prompt, or start from a ready-to-run package and adapt it
• Answer questions about how a component behaves, with a link to the source
• Manage packages through edits that land in a draft, not the live version

Helm designs and builds; the Integrate.io platform executes. A pipeline that ships stays deterministic and runs the same way every time. Nothing becomes production until you review and approve.

Helm Ask is on for every account, Helm Build is enabled per account by our team, and the documentation has the full picture.

Smart Map and Smart Transform Take the Slowest Step Out of Pipeline Delivery

Smart Map removes field-by-field setup. Point the platform at your destination schema and it automaps your source data to the matched schema output, including renames and type conversions. Smart Transform works at the field level: describe the transformation in a prompt or give a before and after example, and it generates the Integrate.io transformation expression for you. Suggestions are validated against your own data before you accept them, so what you review is what runs. Both are available on request, and the documentation covers what they can do.

Package Drafts and Autosave Keep In-Progress Edits Safe

Losing package edits to a closed tab or a dropped connection used to be a real risk, since nothing was stored until you explicitly saved a version. The designer now autosaves your work to a private per-user draft after you stop editing, and again when you leave the editor. Reopening a package that has a draft asks whether to resume the draft or open the last saved version, and a Discard Draft button in the toolbar throws the draft away when you want to start clean. Draft autosaves stay out of version history, so only explicit saves create a version. Full setup details are in the documentation.

The Run Workflow Task Runs Workflows Inside Workflows

Reusing one workflow as a step inside another previously meant duplicating its tasks by hand and keeping both copies in sync. The Run Workflow task executes another workflow as a sub-run of the current one, so a long orchestration can be split into smaller workflows that also run on their own. Read the documentation for the nesting limit and variable scoping rules.

New Connectors

• Salesforce REST API Destination: A new Salesforce destination built on the REST API supports insert, upsert, update, and delete across throttled single-record and batched write modes, and produces per-record success and failure CSV outputs. It works with both standard and customer-managed OAuth Salesforce connections, giving teams an alternative to the Bulk API for smaller or latency-sensitive writes (documentation).
• Databricks Destination: Pipelines can now write to Databricks, with staging and load handled for you so output lands in your tables without a manual copy step. Teams running on the lakehouse can send ETL output to Databricks directly instead of routing it through an intermediate warehouse first (documentation).
• Trustpilot Source: A native Trustpilot source pulls reviews, review categories, and private reviews for a business unit, with incremental load supported. Review data can now be joined against the rest of a customer dataset without maintaining a custom API pull (documentation).

New Features

• Live Preview in the Expression Editor: The expression editor now runs the current expression against five real sample rows from the previous component and shows each input value next to its result. Expressions can be checked while you write them instead of after a job fails.
• Field Data Types in the Select Component: The Select component's field list now shows a data type for every output field, and the expression editor shows the return type for most functions, fields, and variables. Where a type cannot be inferred statically, running a preview fills the column in.
• Separate Read and Write Access for AI Tools: Helm and MCP capabilities are now split into distinct read and write tool sets, so inspection, previews, and searches can be opened up broadly while package edits, schedules, and job runs stay restricted. Write access is closed by default, and our team can open it up for an account on request.
• Package Group to Connection Group Binding: A package group can now be bound to specific connection groups, restricting its packages to connections from those groups. Admins get a direct way to keep one team's pipelines from reaching another team's credentials.
• AddToDate and ToDateOrNull Functions: Two new expression editor functions cover date arithmetic and parsing that returns null rather than failing on an unparseable value. Date handling that previously needed nested conditionals now fits in a single call.

Improvements

• SFTP connections now support private key plus password authentication, covering servers that require a multi-factor login.
• Job logs, the logs API, and AI error summaries mask connection credentials, and account-level global secrets are masked in job and workflow variable views.
• Chatmeter, Corrigo, and GoTo sources now paginate through results, so large accounts return their full dataset instead of a first page.
• The Email Report destination accepts variables in its subject and body.
• HubSpot destination has a new Clear when empty flag that clears a HubSpot property when the incoming value is null.
• File and cloud storage destinations can skip writing an output file when a run returns zero rows, an opt-in setting for CSV and JSON.
• The Google Sheets source imports the full sheet schema without manual selection, and can fail a job when the sheet contains no data rows instead of finishing with nothing loaded.
• The Google Ads source adds ConversionsByConversionDate and ConversionsValueByConversionDate to its available metric fields.
• The REST API destination supports a sleep interval between batched requests, giving rate-limited endpoints room between calls.
• Custom role management adds a filter on the roles list and a form for assigning users to a role directly, and the packages and connections lists gained a Show ungrouped only switch.

Fixes

• Package variables are no longer removed when a variables save and a package save run at the same time.
• Package validation succeeds when ExecuteSql or ExecuteSqlDateTime is used in a package variable.
• Draft variables are now executed during schema preview calls.
• The Select component opens correctly when an integer is used as a package variable.
• Source fields with commas in their names, such as long Google Sheets headers, now carry their values into downstream components instead of previewing as null.
• File Storage jobs run correctly when a filename contains parentheses or the source path contains spaces.
• Packages whose variable substitutions produce long file paths no longer crash mid-run.
• SFTP and FTPS sources using a bare wildcard resolve the same file in preview and at job runtime.
• The DB Lookup component's + New button now opens the connection form.
• The Salesforce destination writes error and success record files to shared Google Drive directories when a directory ID is specified.
• The AI error summary reports Salesforce write failures correctly instead of describing them as filesystem handler errors.
• Packages inside a package group with connection group restrictions now save correctly.
• Global secret variables evaluate correctly in the cases that previously failed.
• Invitations work for users assigned a custom role, and the user management page is restricted to administrators.
• The owner role shows its label and filter on the user list and is assigned correctly on the roles view.

Performance Enhancements

• The Google Ads source can split a long date range into parallel chunks, cutting pull times on wide reporting windows. Set _ADWORDS_API_DATE_SPLIT_ENABLED to true in your package variables to switch it on, with _ADWORDS_API_DATE_SPLIT_CHUNK_DAYS and _ADWORDS_API_DATE_SPLIT_MAX_CHUNKS controlling the split.
• The Google Sheets source reads large sheets in batches rather than loading a whole sheet in a single pass, clearing the out-of-memory, read-timeout, and missing-row failures that wide or long sheets used to hit.

Give the new AI tooling a run this month and tell us where it saves you time and where it still needs work.