Set Up, Test, and Activate an n8n Workflow
Create the sheets and tables an n8n workflow expects, replace placeholder values, set the timezone, then test and activate it, with fixes for common problems.
On this page
With the workflow imported and its credentials connected, a few small changes make it yours. Then one test run tells you it's ready to switch on.
Set up your data
Workflows that store or read data list the tables they need under Data setup on their page, with the exact column names.
Google Sheets
- Create a spreadsheet and name its tabs to match the setup.
- Put the column names in the first row of each tab, spelled exactly as shown.
- In each Google Sheets node, choose your spreadsheet and tab from the lists.
Airtable
- Create a base with the tables listed.
- Add fields with the exact names shown.
- In each Airtable node, choose your base and table.
Point nodes at your own accounts
Some nodes point at a specific place, like a Google Drive folder, a Slack channel, or a calendar. Open each one and choose your own from the list.
Replace placeholders
Some nodes hold sample values so the workflow is complete out of the box. Look for example email addresses, phone numbers, and links that contain YOUR-FORM-ID, and swap in your own. The README that comes with each workflow points out where they are.
Set the timezone and date format
Every workflow is set to the America/New_York timezone and writes dates as MM/DD/YYYY.
- To change the timezone, open the editor menu, choose Settings, and pick yours under Timezone.
- To change the date format, edit the nodes that format dates, usually a Set, Code, or Date & Time node.
Test the workflow
- Click Execute workflow at the bottom of the canvas. If the workflow starts from a form, webhook, or incoming message, send a real test while it's listening.
- Click through each node and check its output.
- Fix any node that shows an error, then run it again until every node is green.
Activate it
Turn on the Active toggle at the top of the editor. From then on, schedules run on time and triggers fire on their own.
If another app sends data to the workflow, like Twilio or a form tool, give it the webhook's production URL. The test URL only works while the editor is listening.
Troubleshooting
A node shows a warning after import
It usually needs a credential, so open it and pick one. If the node itself won't open, your n8n is older than the version the workflow was built on. Update n8n and import again.
A Google Sheets or Airtable node can't find a column
Check the header row of your sheet, or the field names in your table, against the Data setup on the workflow's page. Names have to match exactly.
The trigger never fires
Schedules, webhooks, and app triggers only run on their own once the workflow is active. For webhooks, make sure the other app uses the production URL.
The AI step fails
Make sure your OpenAI credential has a valid API key and the account has billing set up. Then run that node on its own to see the full error.
Emails or messages don't arrive
Check that you replaced every placeholder recipient and that the sending credential is connected. Then look in the receiving inbox's spam folder.
