The Problem Was Simple
A bot ran every morning on a Windows device. Another bot ran every evening on a Mac mini. Both watched the same Google Sheet, but because they operated at different times, data update timing often fell out of sync.
「Is this just a scheduling issue?」 We thought so, but it turned out to be much more.
An Unexpected Discovery
One day, when the Mac mini bot's processed data was received by the Windows device bot, something changed. The Windows device recognized, "Oh, this data is already sorted," and skipped the duplicate review it was supposed to do.
As a result, processing time dropped by 40%.
At first we thought it was a bug. But after the same pattern repeated for three consecutive days, we realized this wasn't a bug at all. It was an unintended collaboration system.
The Potential of Cross-Platform Automation
「Bots running on different devices can 'talk' to each other through Google Sheets as a common language」
Mac and Windows, Claude Code and Apps Script, Google Forms and Sheets. The point where they meet is ultimately data. When you align the data format, the boundaries between platforms are surprisingly porous.
Based on this, we tried the following:
1. The Mac mini bot leaves a 「completion flag」 in the processed data
2. The Windows device bot reads that flag and moves to the next stage
3. Intentionally set the time interval to 3 hours to maintain a natural flow
The results exceeded expectations. The 「manual data handoff」 stage that we used to do disappeared entirely.
What a Non-Developer Learned
Automation wasn't just about each bot operating perfectly and independently. Designing the 'conversation' between bots was the more critical part.
Even running on different operating systems and different tools, bots can recognize each other if we establish a common data format (spreadsheet cells, timestamps, tags) as the basis. This concept was more powerful than we imagined.
「What if we added a third bot?」
We're experimenting with that idea right now.