Preparing data to be sent to a service

n8n template #1751

Summary

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

How to set it up

Open template #1751 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create a credential under Credentials → Add credential: Google Sheets. Then open each of those nodes and pick the credential.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Preparing data to be sent to a service" (https://n8n.io/workflows/1751). It uses: Google Sheets, Customer Datastore (n8n training). Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Google Sheets Customer Datastore (n8n training)

Questions

Yes. Jonathan published it free on n8n.io as a verified creator, and it has 64K views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets. The other 1 node are built into n8n.

Similar workflows

NameViews