WHAT THIS DOES
Use a Google Sheet or Airtable Base as a live content editor to add/edit Page content in MOBLE. When rows are added or updated, n8n automatically syncs them to MOBLE Pages, updating your site and AI Knowledge Base. All results are recorded to a Google Sheets Sync Log (even when Airtable or another app is the source).
SETUP
1. Create Your Source Sheet (Google Sheets or Airtable)
- Create two Google Sheets using these names:
- Download and open the templates above to scaffold the correct headers.
- Important: The n8n workflow looks for these default file names.
- Document: MOBLE-Pages-Source-Sheet
Sheet (Tab): Pages - Document (Logs): MOBLE-Pages-Sync-Log
Sheet (Tab): Sync Log
- If you rename your sheets, that’s fine — just make sure to update the names in the n8n node under each Google Sheets or Airtable node to match exactly.
- Note: If the URL column is blank, the workflow auto-generates page_url (slug) from Title.
2. Import the n8n Workflow
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-Pages-Source-Sheet
- Sheet: Pages
- If you changed the Sheet names in Step 1, use the new Sheet Name.
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-Pages-Source-Sheet
- Table: Pages
- If you changed the Table names in Step 1, use the new Sheet Name
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 Google Sheets Sync Log nodes intact.
- Important: Enable only one source trigger (Google Sheets or Airtable or your swapped app) to avoid duplicate runs.
4. Add Google Sheet Sync Log Credentials (in n8n)
- Click the node titled Log to Consolidated Sheet.
- Attach your Google Sheets OAuth2 credential.
- Configure:
- Document: MOBLE-Pages-Sync-Log
- Sheet: Sync Log
- 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
5. Get Your MOBLE API Key (in MOBLE)
- Go to MOBLE → Global Settings → Integrations → MOBLE API Key
- Copy 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 Page
- MOBLE API: Update Page
- 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):
Title: Test Page
Page Content: <p>Hello</p>
- Check MOBLE → Pages look for new “Test Page”.
- Check MOBLE-Pages-Sync-Log → Sync Log for action: create, status: success.
- Once verified, toggle the workflow to Active for live syncing.
SOURCE SHEET COLUMNS (EXACT HEADERS)
- Title — The display name of the page (maps to page_name).
- URL — Unique slug for page_url (e.g., about-us). Leave blank to auto-generate from Title.
- Page Content — Main HTML content (page_content).
- Editor Content — Structured HTML used by the editor (editor_content).
- KB Content — Plain text/markdown for AI Knowledge Base (kb_content).
- Summary — Short description (summary).
- AI Summary — Short summary used in Chatbot carousel (ai_summary).
- AI Instruction — Guidance for the Chatbot on how/when to use the Page (ai_instruction, if enabled).
- AI Tags — Comma-separated tags for AI segmentation (e.g., voice, faq) (ai_tags).
- KB Status — Include in AI Webmind (TRUE/FALSE) (kb_status).
- Chatbot Icon URL — Image for chatbot/social previews (chatbot_icon_url).
- Tags — Comma-separated tags for widgets (tags).
- Priority — Priority of the Page; influences Chatbot search results (priority).
- Importance — Importance to the business (impact/profitability) (importance).
- Author — Content author (author).
- Display Date — Date shown on page (YYYY-MM-DD) (display_date).
- Sort Order — Ordering key for widgets (sort_order).
- Meta Title — HTML title tag (title).
- Meta Description — SEO description (meta_description).
- Meta Keywords — Comma-separated keywords (meta_keywords).
- Meta Tags — Raw HTML/script tags (meta_tags).
- Page Status — draft or published.
- Member Access — Restrict access (Yes or group name) (member_access).
- Hide Header — TRUE/FALSE (hide_header).
- Hide Footer — TRUE/FALSE (hide_footer).
- Destination URL — Redirect target (destination_url).
- File URL — External file link (file_url).
- Publish Date — Scheduled go-live (YYYY-MM-DD) (publish_date).
- Take Down Date — Scheduled unpublish (YYYY-MM-DD) (take_down_date).
- Option 1 … Option 15 — Flexible custom fields (option_1 … option_15).
REPORT: SYNC LOG (GOOGLE SHEETS)
- timestamp — When the sync ran.
- page_url — Slug that was created/updated.
- page_name — Title processed for this run.
- action — create, update, or validation.
- status — success or error.
- details — Short result note (e.g., new page ID).
- error_message — Why it failed (if any).
- http_status — API code (e.g., 201, 200, 409) or 0 for validation errors.
TROUBLESHOOTING
- Nothing syncing: Ensure the workflow is Active and only one source trigger is enabled.
- 401/403: MOBLE API key missing/invalid. Header must be Authorization: Bearer ak_XXXXXXXX on both API nodes.
- 409: Page already exists. The workflow auto-switches to update.
- No Sync Log: Confirm the Google Sheets credential and names: MOBLE-Pages-Sync-Log / Sync Log.
- Validation errors: Ensure Title is filled; URL may be left blank to auto-generate.
SECURITY: Restrict n8n access to trusted staff. Rotate API keys quarterly.