This works fine for table-based data, but fails to protect text and the many [potentially] embedded data and analytics in texts. Then there’s images embedded in texts - a lot to think about and mentioned here.
Here’s how I create a full-text search and also capture important Coda-based texts.
- Create an automation that emails each important section to a role account in G-Suite.
- Harvest inbound emails from the automation process in Coda.
- Transform the section content into a Google Drive document where the name is the section title that creates a new document when one doesn’t exist, and simply overwrites one that already exists.