What you'll build
This guide will help you create an automated workflow that logs every AI conversation to a Google Spreadsheet in real-time. Every time you send a message and receive an AI response, a new row will automatically appear in your spreadsheet with details like the prompt, response preview, model used, and timestamp.
Time Required
~10 minutes
Cost
Free tier available (100 tasks/month)
Skill Level
Beginner-friendly, no coding
Prerequisites
Required Accounts
- ✅ Mimesys AI account (with access to Settings)
- ✅ Zapier account (free tier works)
- ✅ Google account (for Google Sheets)
What You'll Need
- • Web browser (Chrome, Firefox, Safari)
- • 10 minutes of uninterrupted time
- • Access to Mimesys AI Settings page
Step-by-Step Guide
Create a Webhook in Mimesys AI
- 1. Go to Settings → Webhooks in Mimesys AI
- 2. Click "Create Webhook"
- 3. Enter the following:
- • Name: "Zapier Integration" (or any name you like)
- • URL: Leave blank for now - we'll get this from Zapier
- • Events: Check "Message Completed"
- • Enable webhook: Check this box
- 4. Click "Create"
- 5. SAVE THE SECRET shown on screen (you won't see it again!)
Note: Don't worry about the URL being blank - we'll add it in Step 3 after getting it from Zapier.
Set Up Zapier Webhook
- 1. Log into Zapier
- 2. Click "Create Zap"
- 3. Choose trigger:
- • App: Webhooks by Zapier
- • Event: Catch Hook
- • Click Continue
- 4. Copy the webhook URL shown by Zapier (you'll need this in the next step)
What is "Catch Hook"? This tells Zapier to wait and listen for incoming data from Mimesys AI. Once it receives a test event, it will show you all the available fields.
Connect the Webhook
- 1. Go back to Mimesys AI → Settings → Webhooks
- 2. Click "Edit" on your webhook
- 3. Paste the Zapier webhook URL you copied in Step 2
- 4. Click "Update"
Send a Test Event
- 1. In Mimesys AI, click the "Test" button on your webhook
- 2. Go back to Zapier
- 3. Click "Test trigger"
- 4. You should see test data appear with all the webhook fields!
Success! If you see the test data in Zapier, the webhook connection is working. The test data shows Zapier what fields are available - you'll use these to map to your spreadsheet.
Connect to Google Sheets
- 1. Click "Continue" in Zapier
- 2. Choose action:
- • App: Google Sheets
- • Event: Create Spreadsheet Row
- • Click Continue
- 3. Connect your Google account (if not already connected)
- 4. Select your spreadsheet and worksheet
- 5. Map fields (see Field Mapping Reference below)
- 6. Click "Test action" to verify
- 7. Click "Publish" to turn on your Zap
Field Mapping Reference
Set up your Google Sheet with these column headers in Row 1, then map the webhook fields in Zapier:
| Column | Header Name | Zapier Field to Select |
|---|---|---|
| A | Event | Event |
| B | Timestamp | Timestamp |
| C | Conversation ID | Conversation ID |
| D | Record ID | Record ID |
| E | User Reference | User Reference |
| F | Prompt Preview | Prompt Preview |
| G | Response Preview | Response Preview |
| H | Response Length | Response Length |
| I | Model Used | Model Used |
| J | Model Provider | Model Provider |
| K | Status | Status |
How to map: In Zapier, for each column click the + button, search for the matching field name from the webhook, and select it from the dropdown. Zapier will automatically fill each row with new webhook data.
Done!
From now on, every time the AI completes a message, a new row will appear in your spreadsheet automatically!
Common Issues
Webhook not triggering
Check:
- • Is the webhook enabled? (Settings → Webhooks)
- • Is "Message Completed" event selected?
- • Check the "Last Error" field for issues
Missing data in spreadsheet
Check:
- • Are field names in Zapier correctly mapped?
- • Is your Zap turned on? (check Zapier dashboard)
- • Check Zapier's task history for errors
Running out of Zapier tasks
Each webhook = 1 Zapier task. Free tier = 100 tasks/month.
Solution: Disable webhooks when not needed (Settings → Webhooks → Disable) to save your quota.