Make.com NocoDB-GoogleSheets Column Automation

I need a Make.com scenario that ingests rows from NocoDB (Array, that filters certain items) and updates an e-commerce flat-file stored in Google Sheets. For every incoming record the scenario must inspect the Item Specifics column and search for the exact text “Item Specifics”.

If the text is present, the flow should write that row’s value into a companion column called “C-" and what ever "Item Specifics” name is from the Array value. If the column is missing in the sheet, the scenario must create the column first—automatically appending the “C-” prefix—then populate the correct cell before moving on.

Item Specifics can later contain different values such as Material, Color, or Size, so please build the logic so that additional values are treated the same way without breaking the flow.

Deliverables
• A Make.com blueprint (.json) ready for import
• Clear setup documentation covering every module, mapping, filter, and the authentication link between NocoDB and Google Sheets
• A quick-start guide that lets another user plug in credentials, run the scenario, and watch it create or update “C-Item Specifics” with zero validation warnings or errors

Acceptance criteria: importing the blueprint shows no warnings, processing a sample sheet creates/updates “C-Item Specifics” exactly as described, and all rows sync successfully from NocoDB to Google Sheets.