Hi Everyone,
I’m looking to set up n8n to dynamically update the schema of any Google Sheet I’m using as a database. I currently have around 100 Google Sheets, each with a unique schema. The first row always contains the headers, but the number of columns varies across the sheets. I need n8n to handle changes to these schemas, such as adding or removing columns, and automatically sync these updates to Airtable.
I’ve figured out how to automate adding rows, so I’m not concerned about that. However, I want to ensure that any changes to the structure of my Google Sheets are reflected in Airtable dynamically.
The Airtable module allows me to retrieve the schema, but I don’t see an option to create or update it. How can I set up a custom solution in n8n to achieve this? Any suggestions or guidance would be greatly appreciated!