Source Sheet (Google Sheets or Airtable) → n8n Workflow → MOBLE Products API → MOBLE Products → MOBLE Knowledge Base → Google Sheets (Sync Log)

This lets non-technical teams edit a shared sheet while n8n keeps MOBLE updated and writes a clear Sync Log for review.

Use a Google Sheet or Airtable Base as a live product editor to add/edit Products in MOBLE. When rows are added or updated, n8n automatically syncs them to MOBLE Products, updating your site and AI Knowledge Base. All results are recorded to a Sync Log (Google Sheets or Airtable).

1. Create Your Source Sheet (Google Sheets or Airtable)

• Create two Google Sheets using these names:
  • MOBLE-Products-Source-Sheet — your main products sheet (tab: Products)
  • MOBLE-Products-Sync-Log — your results log (tab: Sync Log)
• Download and open the templates to scaffold the correct headers:
  • MOBLE-Products-Source-Sheet.xlsx
  • MOBLE-Products-Sync-Log.xlsx
• Defaults the workflow looks for:
  • Document: MOBLE-Products-Source-Sheet   
    Sheet (Tab): Products
  • Document (Logs): MOBLE-Products-Sync-Log   
    Sheet (Tab): Sync Log
• If you rename your sheets, that’s fine — just make sure to update the names in n8n under each Google Sheets or Airtable node to match exactly.
• Note: If the URL Slug column is blank, the workflow will auto-generate the slug from Product Name.

2. Import the n8n Workflow

• In n8n → Create Workflow → Import from File → select your template:
  • MOBLE-Products_Google-Sheets→MOBLE.json
  • MOBLE-Products_Airtable→MOBLE.json
• The workflow opens in the editor; leave it Inactive until setup is complete.

3. Add Trigger Node Credentials (in n8n)

Google Sheets Trigger Node

• Click the Trigger Node titled When Row Added or Updated.
• Under Credential to connect with, click + Create New Credential, choose Google Sheets OAuth2, complete sign-in, then Save.
• Configure:
  • Document: MOBLE-Products-Source-Sheet
  • Sheet: Products
  • If you changed the names in Step 1, use your new names.

Airtable Trigger Node

• Click the Trigger Node titled When Record Created or Updated.
• Under Credential to connect with, click + Create New Credential, choose Airtable OAuth2 (or Personal Access Token), authorize, then Save.
• Configure:
  • Base: MOBLE-Products-Source-Sheet
  • Table: Products
  • If you changed the Base/Table names in Step 1, use your new names.

Swap to Other App Trigger Node

• Open the Sticky Note titled App Swap Prompt inside the workflow.
• Copy its text into n8n’s Text-to-Workflow Assistant, edit for your chosen app and the fields you need, then apply.
• The Assistant replaces the source trigger while keeping the MOBLE API and Sync Log nodes intact.
• Important: Enable only one source trigger (Google Sheets or Airtable or your swapped app) to avoid duplicate runs.

4. Add Sync Log Credentials (in n8n)

Google Sheets — Log to Consolidated Sheet

• Click the node titled Log to Consolidated Sheet.
• Attach your Google Sheets OAuth2 credential.
• Configure:
  • Document: MOBLE-Products-Sync-Log
  • Sheet: Sync Log
    
  • If you changed the Document/Sheet names in Step 1, use your new names.
• This node records every API response (create, update, error) into your log sheet.
• Sync Log Columns (8): timestamp, page_url, page_name, action, status, details, error_message, http_status

Airtable — Log to Sync Log Table

• Click the node titled Log to Sync Log Table.
  
• Add Airtable credential (Personal Access Token or OAuth2).
  • Select Base: MOBLE-Products-Sync-Log
  • Select Table: Sync Log.
  • If you changed the Base/Table names in Step 1, use your new names.
• What it logs: All sync activity to one table:
  • Create success & Update success
  • API errors
  • Validation errors
• Fields (create these columns in Airtable):
  • MOBLE-Products-Sync-Log.xlsx
• Field types: Use Single line text for simple logging. For structured fields, use:
  • timestamp → Date or Date time
  • http_status → Number (optional)

5. Get Your MOBLE API Key (in MOBLE)

• Go to MOBLE → Global Settings → Integrations → MOBLE API Key.
• Copy your MOBLE API Key. Keys start with ak_.
• Keep this key safe — you’ll add it to n8n next.

6. Add MOBLE API Credentials (in n8n)

• Add the same Header credential to both nodes:
  • MOBLE API: Create Product
  • MOBLE API: Update Product
• For each node:
  • Click the node → Credential to connect with → + Create New Credential → select Header Auth.
  • Paste MOBLE API Key, for Name write Authorization:
    • Name: Authorization
    • Value: Bearer ak_XXXXXXXXXXXXXXXX
  • Save and reselect the credential in both nodes.

7. Test, Then Activate

• Click Execute Workflow (manual run).
• Add a simple row in your chosen Source Sheet (Sheet or Airtable):

Product Name: Test Product
URL Slug: test-product
Price: 9.99

• Check MOBLE → Products for the new “Test Product”.
• Check your Sync Log (Google Sheets or Airtable) for action: create, status: success.
• Once verified, toggle the workflow to Active for live syncing.

These map to the MOBLE Products API. At minimum, provide URL Slug or Product Name (to auto-generate the slug).

• Product Name — Display name
• URL Slug — Unique slug
• Status — draft/published
• Summary — Short description
• Description — Long description (body)
• Price — Number
• Quantity — Integer (stock level)
• SKU / Barcode / Code — Identifiers
• Tags / Related Tags — Comma-separated
• Image URL / Headline Image URL
• Author / Display Date / Sort Order
• Item Category / Item Type / Item Vendor
• Headline — Featured title
• Priority / Importance — Integers (used for AI/search weighting)
• AI Include / AI Summary — For Knowledge Base/AI carousel
• Meta Title / Meta Description / Meta Keywords
• Publish Date / Take Down Date — YYYY-MM-DD
• Shipping Rates — Optional flat-rate fields (if used)
• Option 1 … Option 15 — Flexible custom fields

• timestamp — When the sync ran.
• page_url — Product slug that was created/updated.
• page_name — Product name processed for this run.
• action — create, update, or validation.
• status — success or error.
• details — Short result note (e.g., created or updated).
• error_message — Why it failed (if any).
• http_status — API code (e.g., 201, 200, 409) or 0 for validation errors.

• Nothing syncing: Ensure the workflow is Active and only one source trigger is enabled.
• 401/403: API key missing/invalid. Header must be Authorization: Bearer ak_XXXXXXXX on both API nodes.
• 409: Product already exists — the workflow should switch to update automatically.
• No Sync Log: Confirm the credential and names for your chosen log destination (Google Sheets or Airtable).
• Validation errors: Ensure Product Name or URL Slug is filled; slug will auto-generate from Product Name if left blank.
• Dates not parsing: Use YYYY-MM-DD.
• Booleans: Use yes/no, true/false, 1/0 (lowercase preferred).

SECURITY: Restrict n8n access to trusted staff. Rotate API keys quarterly.