How do I adjust my AI agent and Google Sheets workflow to append the correct data?

Below is some guidance on what to review in your workflow configuration:

1. Inspect Your Field Mapping

It sounds like the node is set up to pull in the Document ID and SheetName instead of your intended data when appending data. In your Google Sheets node configuration, check the field mapping (often in the “Mapping Column Mode”) and ensure that only the columns you want are selected. If you see default mappings for Document ID or SheetName, remove or modify them so that your data fields take precedence.

2. Refresh Column Names

If your spreadsheet’s columns have been changed or were not correctly updated when you set up the node, you may see unexpected fields.

• Re-open the node’s settings
• Re-select the Mapping Column option (sometimes this forces the node to re-fetch the live column names from your sheet)

This is a common fix when the spreadsheet’s schema has changed after setting up the workflow.

3. Review Data Passing from the AI Agent

Since you’re integrating an AI agent that provides data into the workflow, ensure that the data coming from the Agent is correctly formatted. Check that:

• The data output is in the right structure (like a JSON formatted object with key/value pairs corresponding to your desired columns)
• You’re not inadvertently passing the metadata (such as the Document ID or SheetName) instead of your actual content

4. Double-check Operation Selection

Since you mentioned using two Google Sheets Tools, confirm that one of them is set to the correct operation (for example, Append Row) rather than an operation that might expect or carry along document metadata. If one node is creating the document and the subsequent node appending data, review the handover of variables between the two nodes.

---

By verifying your column mapping, refreshing the columns if they’ve changed, and ensuring that the AI agent is providing the correct data format, you should be able to have your workflow append only the expected data.