Preparing data to be sent to a service

Go to Workflow
63,641 views
Built by Jonathan Jonathan
Created on June 05, 2026

Description

Task:
Make sure that data is in the right format before injecting it into a database/spreadsheet/CRM/etc.

Why:
Spreadsheets and databases require the incoming data to have the same fields as the headers of the destination table. You can decide which fields you would like to send with the database and rename them by using the set node

Main use cases:
Change fields names to match a database or a spreadsheet table structure
Keep only the fields that are needed at the destination table

Nodes Used (2)

Customer Datastore (n8n training)
n8n-nodes-base.n8nTrainingCustomerDatastore
Google Sheets
n8n-nodes-base.googleSheets