WHAT THIS DOES
Use a Google Sheet or Airtable Base as a live content editor to add/edit FAQs in MOBLE. When rows are added or updated, n8n automatically syncs them to MOBLE FAQs, 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.
- Default names the workflow expects:
- Document: MOBLE-FAQs-Source-Sheet
Sheet (Tab): FAQs - Document (Logs): MOBLE-FAQs-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 auto-generates it from Question.
2. Import the n8n Workflow
- Open n8n → Create Workflow → Import from File → select your FAQ workflow (.json).
- Use the template for your source:
- MOBLE-FAQs_Google-Sheets→MOBLE.json
- MOBLE-FAQs_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-FAQs-Source-Sheet
- Sheet: FAQs
- If you changed the names in Step 1, use your new names here.
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-FAQs-Source-Sheet
- Table: FAQs
- If you changed the names in Step 1, use your new names here.
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 fields, 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-FAQs-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 your MOBLE API Key (starts 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 FAQ
- MOBLE API: Update FAQ
- For each node:
- Click the node → Credential to connect with → + Create New Credential → select Header Auth.
- Paste MOBLE API Key, set:
- 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:
Question: What are your support hours?
Answer: We’re available 9am–5pm, Monday to Friday.
- Check MOBLE → FAQs for your new FAQ.
- Check MOBLE-FAQs-Sync-Log → Sync Log for action: create, status: success.
- Once verified, toggle the workflow to Active for live syncing.
SOURCE SHEET COLUMNS (EXACT HEADERS)
- Question — The FAQ question (maps to faq_question or title).
- Answer — The answer (HTML or text) (faq_answer / content).
- URL — Unique slug (e.g., shipping-times) (faq_url). Leave blank to auto-generate from Question.
- Category — Group/section for the FAQ (category).
- 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 this FAQ (ai_instruction, if enabled).
- AI Tags — Comma-separated tags for AI segmentation (e.g., faq, shipping) (ai_tags).
- KB Status — Include in AI Webmind (TRUE/FALSE) (kb_status).
- Tags — Comma-separated tags for widgets/filters (tags).
- Priority — Priority; influences Chatbot search (priority).
- Importance — Business impact/significance (importance).
- Display Date — Optional date shown with the FAQ (display_date).
- Author — Content owner/author (author).
- Sort Order — Ordering key (sort_order).
REPORT: SYNC LOG (GOOGLE SHEETS)
- timestamp — When the sync ran.
- page_url — Slug created/updated (the FAQ URL).
- page_name — The Question processed for this run.
- action — create, update, or validation.
- status — success or error.
- details — Short result note (e.g., new FAQ 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: FAQ already exists. The workflow auto-switches to update.
- No Sync Log: Confirm the Google Sheets credential and names: MOBLE-FAQs-Sync-Log / Sync Log.
- Validation errors: Ensure Question is filled; URL may be left blank to auto-generate.
SECURITY: Restrict n8n access to trusted staff. Rotate API keys quarterly.