Why Isn't My Airtable Table Receiving Data from Google Sheets?

Below is a list of steps and things to check when experiencing an issue where the Airtable node isn’t creating any records despite your workflow running without errors:

1. Verify the Output from Google Sheets

• Data Structure: Confirm that the “get rows” operation from the Google Sheets node returns the data in the expected format. The Airtable node expects an array of items with properties that match your Airtable fields.
• Preview the Data: Use the "Execute Node" feature (or add a temporary Set or Code node) after the Google Sheets node to inspect the output. Ensure each item includes the correct property names and values.

2. Check Mapping in the Airtable Node

• Field Names: Ensure that the field names in the Airtable node’s mapping exactly match the output keys from Google Sheets. Even if the table’s row names (or spreadsheet column headers) look similar, a mismatch in spelling or case could prevent the data from being mapped correctly.
• Mapping Mode: Some nodes require explicit mapping of fields. If the Airtable node has an option for mapping or column mode, try re-selecting your mapping fields to force a refresh of the available options.

3. Confirm Airtable Credentials and Table Settings

• Credentials: Even though no error is thrown, double-check that your Airtable credentials are correct and that they have the necessary permissions to create records in the target table.
• Table Configuration: Make sure your Airtable table is set up correctly and that you have the correct table selected within the node settings.

4. Test with a Simple Data Set

• Simplify the Workflow: To isolate the issue, try creating a simple workflow that passes static data or a single row from a Google Sheets node directly to an Airtable create node. This can help confirm whether the issue lies with data conversion or with Airtable configuration.
• Use a Code or Set Node for Debugging: If necessary, add a Code node between the Google Sheets and Airtable nodes to log or adjust the data format. For example:

JAVASCRIPTCopied
// Example Code node to transform data
return items.map(item => {
  return {
    json: {
      // Ensure keys here match your Airtable field names
      Name: item.json.name,
      Email: item.json.email,
    }
  };
});

5. Review Workflow Execution Data

• Workflow Logs: Even if no errors are visible, check the execution logs or inspect the data passed between nodes. This can reveal if the downstream node is receiving data items or if the data is nested differently than expected.

By following these troubleshooting steps, you should be able to determine whether the issue is with how the data is retrieved from Google Sheets, how it is being mapped into Airtable, or with the Airtable node configuration itself.

Give these steps a try and adjust your workflow accordingly. Let me know if you need further guidance on any of the specific steps!