n8n AI Agent: Let the Model Fill Your Google Sheets Columns. Make the System Prompt and the Header Row One Schema

The smallest agent in n8n can handle tasks like generating social media post ideas and saving them to a Google Sheet. The secret to making this work consistently lies in aligning the system prompt's output format with the spreadsheet's header row. This shared schema ensures that the model knows exactly which data belongs in which columns.

To set this up, first design a clear schema for each "idea." For instance, BrightPath Marketing's idea format includes Platform, Post Topic, Hook, Description, and Call to Action. These fields should appear in two places: the spreadsheet header row and the model's output format.

Next, construct a system message that instructs the model to return data in the exact same format. This message should specify the five fields and the agency's name. Then, tell the model to use Google Sheets' Append Row tool each time it generates an idea. The connection between the model's output parameters and the spreadsheet headers is crucial; describe each parameter within the system message using the $fromAI() function.

Testing involves sending a request for three ideas and checking if they appear in the spreadsheet with the correct columns. If something goes wrong, revisit the system message to ensure field names match the spreadsheet headers. Once the schema is correctly established, this pattern can be reused for various types of data, making the process highly versatile.