Make.com NocoDB-GoogleSheets Column Automation

$10-30 USD

Suljettu

Julkaistu 21 päivää sitten

$10-30 USD

Maksettu toimituksen yhteydessä

I need a [login to view URL] 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 [login to view URL] 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.

Projektin tunnus (ID): 40253290

Tietoa projektista

29 ehdotukset

Etäprojekti

Aktiivinen 18 päivää sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

29 freelancerit tarjoavat keskimäärin $27 USD tätä projektia

@matheussilva114

Hi there, THE CHALLENGE is to seamlessly integrate NocoDB and Google Sheets while ensuring accurate and consistent updates to the e-commerce flat-file. One potential difficulty could be handling dynamic changes in the Item Specifics column, such as new values being added or existing ones being modified. To address this, I would implement a flexible logic that can adapt to any changes in the Item Specifics values without disrupting the flow. By creating a robust system that can automatically create missing columns, append prefixes, and accurately update the companion column, I will ensure smooth and error-free data synchronization between NocoDB and Google Sheets. Regards, Matheus.

$10 USD 7 päivässä

5,0

(2 arvostelut)

0,6

@michaelv288

✨✨✨Dear Respected Client✨✨✨ I reviewed your Make scenario with NocoDB and Sheets sync. Flow must detect “Item Specifics” and map dynamic C- columns. I built complex Make automations with dynamic fields before. Scenario will create missing C- columns automatically. Array values like Material or Size handled generically. Google Sheets updates will avoid duplicates and errors. Blueprint JSON and full setup docs will be provided. Thank you for hiring me.

$20 USD 1 päivässä