Connecting Google Sheets


Shipped
Last Updated: 3 hours ago

If you have internal knowledge—such as product FAQs, troubleshooting steps, or other reference material—you can upload a Google Sheet to automatically create knowledge base articles within the Shipped Suite merchant admin.


Step 1: Connect Google Sheets

  1. In the Shipped Suite merchant admin, go to AI Agents > Channels.

  2. Under the Knowledge Base section, locate Google Sheets and click Connect.

  3. When prompted, authorize the necessary permissions.

  4. Once connected, you’ll be directed to the Settings page to upload your Google Sheet.


Step 2: Upload and Configure the Sheet

  1. From AI Agents > Channels, click on Settings under the Google Sheets section.

  2. Complete the following configuration fields:

    • Google Sheet ID

    • Sheet Name (optional)

      • Enter the name of the sheet tab you want to upload (e.g., “FAQs”).

      • Leave blank to default to the first sheet.

    • Title Column

      • Enter the column number to be used for article titles.

    • Content Columns

      • Enter the column number(s) for the article content.

      • If content spans multiple columns, list each one (e.g., 3,4,5). These will be combined.

    • Language Column (optional)

      • If your sheet includes non-English content and specifies the language, enter the column number.

      • Leave blank if all articles are in English.

  3. Click Save to complete setup.
    This will trigger the import of the information and create new knowledge base articles within Shipped Suite merchant admin.

Note on Columns

Column numbers are 1-based indexing means the first column is column 1, the second is column 2, and so on.


Maintenance: Syncing Updates

  • When you make changes to the contents of the Google Sheet, use the Manual Sync button to refresh the knowledge base.


Need Help?

If you have any questions or need assistance, feel free to contact our team at support@invisiblecommerce.com.


Was this article helpful?