I want to create a table template given the following context:
Table will need to be duplicated for different clients
Table involves formulas and AI prompts
Table will run according to data it receives from another table (Send Table Data)
The data coming from the source table is from a webhook
Right now the organizational structure is "Master Client" (Folder) > "Sub-Client" (Workbook) > Tables in workbook. What's the best way to create a table template that can serve my use case? Ideally I can easily access this table when I set up a new Sub-Client workbook
The easiest way to handle this is to first create one template workbook inside your master client folder. Build all your tables, formulas and ai prompts inside that same workbook. Once it’s ready every time you onboard a new sub-client just duplicate that workbook, rename it and connect the webhook to the send table data table in the new copy. The entire workflow will start running automatically from the incoming data no remapping needed. This way you don’t rebuild anything again and setting up a fresh client only takes a few clicks.
For your multi-client setup, create a personal template by duplicating your table and moving it to a separate workbook. Add '[Template Do Not Delete]' to the table title for clarity.
Since your table has formulas and AI prompts, also save your column configurations as column group templates—select multiple columns (⌘/ctrl+click), right-click, and choose "Save as template." [1]
For the webhook data flow, use "Write to Other Table" to connect your source table to the template tables in each Sub-Client workbook. [2] Enable Auto-update so new webhook data automatically processes.
This gives you both table structure templates and reusable column configurations for quick Sub-Client setup.
Is that what you were looking for?
Is it recommended to save my template in the same formula, but different workbook?
Yes, that's exactly the recommended approach. Keep your template in the same folder (Master Client) but move it to a separate workbook.
This maintains your organizational structure while giving you a clean template that retains the table frame without data. You can then easily duplicate it when setting up new Sub-Client workbooks. [1]
Did that answer your question?
So create a blank template, add all the formulas and enrichments, and then save it as a template?
Exactly! Create your table with all formulas and enrichments configured, then duplicate it and move to a separate workbook—this creates your template with the structure but no data.
Also save your column configurations as column group templates by selecting multiple columns (⌘/ctrl+click), right-clicking, and choosing "Save as template." [1] This gives you reusable column sets you can quickly apply to new tables.
Was this helpful?
What's more important for my use-case though, saving a table as a template, or saving a group of columns as a template? Don't they accomplish the same job?
They serve different purposes. For your multi-client setup, table templates are more important—they preserve your entire table structure including formulas, AI prompts, and webhook connections.
Column group templates only save column configurations that you can apply to new tables, but won't include your table-level settings like "Send Table Data" connections or auto-update settings. [1]
Since you need the webhook data flow and formulas intact for each client, duplicating your complete table as a personal template gives you everything ready to go.
Does that clarify things?
Based on your original requirements, here's the optimal approach:
Create a personal template:
Build your complete table with formulas and AI prompts
Duplicate it and move to a separate workbook in your Master Client folder
Add '[Template Do Not Delete]' to the title
For webhook data flow:
Use "Send table data" from your webhook source table to push data to each Sub-Client template table. [1] This maintains your organizational structure while automating data distribution.
Why this works best:
Preserves all formulas, AI prompts, and table-level settings
Keeps templates accessible within your Master Client folder
Enables automated webhook data flow to multiple client tables
Easy duplication when setting up new Sub-Client workbooks
This gives you both the template structure and automated data pipeline you need. [2]
Is that what you were looking for?
