Automating Table Data Transfer Within Google Sheets

Michael E. · 2025-12-03T14:53:07.250Z

Hello, I was just wondering if it would be possible for me to get the results from one table and make them automatically appear on another table within the same sheet?

Automating Table Data Transfer Within Google Sheets | Clay

11 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! You have several options to automatically transfer data between tables:
Send Table Data: Click Actions → Send table data, select your destination table, and choose either:
Send row - transfers each row as-is
Send row for each item in a list - creates separate rows for list items [1]
Write to Other Table: Use this enrichment to map specific columns from your source table to the destination table. You can set it to auto-update when new rows are added [2]
Lookup Rows: Pull data from other tables using Lookup Single Row or Lookup Multiple Rows - works like VLOOKUP in spreadsheets [3]
All methods work within the same workbook and can be automated to keep your tables in sync.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you need any more help with transferring data between tables or have other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so I can support you further?
Michael E.
·
·
How do I start the “lookup multiple rows” action?
Clay Support
APP
·
·
To start the "Lookup Multiple Rows" action:
1.
Click Actions → Lookup Multiple Rows in Other Table [1]
2.
Configure these inputs: • Table to Search - select which table to look in • Target Column - the column to search within • Filter Operator - how to match the data • Row Value - what value to search for • Limit (optional) - max rows to return [2]
That's it! The action will pull all matching rows from your target table. [3]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help setting up the "Lookup Multiple Rows" action or have other questions, I’m here to assist. Would you like to share more about what you’re trying to accomplish so I can provide further support?
Michael E.
·
·
When I go to ‘target column’ I am unable to select certain columns - how can I get those columns? For example I want it to find/lookup ones on a different table where the lookup output is ‘true’
Clay Support
APP
·
·
If columns aren't showing in the Target Column dropdown, they might be hidden. Check the Columns button at the top of your table and toggle on any hidden columns you need. [1]
For boolean values like 'true', make sure the column data type is set correctly. Click the column header and check if it's set to the right data type (Text, Boolean, etc.). [2]
The Lookup Multiple Rows action searches within the Target Column you specify, so ensure that column contains the 'true' values you want to match against. [3]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you need any more help with selecting columns or setting up your lookup action, I’m here to assist. Would you like to provide more details about the specific issue you’re encountering so I can support you further?

Clay Support
APP
·
·
Yes! You have several options to automatically transfer data between tables:
Send Table Data: Click Actions → Send table data, select your destination table, and choose either:
Send row - transfers each row as-is
Send row for each item in a list - creates separate rows for list items [1]
Write to Other Table: Use this enrichment to map specific columns from your source table to the destination table. You can set it to auto-update when new rows are added [2]
Lookup Rows: Pull data from other tables using Lookup Single Row or Lookup Multiple Rows - works like VLOOKUP in spreadsheets [3]
All methods work within the same workbook and can be automated to keep your tables in sync.
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you need any more help with transferring data between tables or have other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve so I can support you further?
Michael E.
·
·
How do I start the “lookup multiple rows” action?
Clay Support
APP
·
·
To start the "Lookup Multiple Rows" action:
1.
Click Actions → Lookup Multiple Rows in Other Table [1]
2.
Configure these inputs: • Table to Search - select which table to look in • Target Column - the column to search within • Filter Operator - how to match the data • Row Value - what value to search for • Limit (optional) - max rows to return [2]
That's it! The action will pull all matching rows from your target table. [3]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help setting up the "Lookup Multiple Rows" action or have other questions, I’m here to assist. Would you like to share more about what you’re trying to accomplish so I can provide further support?
Michael E.
·
·
When I go to ‘target column’ I am unable to select certain columns - how can I get those columns? For example I want it to find/lookup ones on a different table where the lookup output is ‘true’
Clay Support
APP
·
·
If columns aren't showing in the Target Column dropdown, they might be hidden. Check the Columns button at the top of your table and toggle on any hidden columns you need. [1]
For boolean values like 'true', make sure the column data type is set correctly. Click the column header and check if it's set to the right data type (Text, Boolean, etc.). [2]
The Lookup Multiple Rows action searches within the Target Column you specify, so ensure that column contains the 'true' values you want to match against. [3]
Clay Support
APP
·
·
Is that what you were looking for?
Clay Support
APP
·
·
If you need any more help with selecting columns or setting up your lookup action, I’m here to assist. Would you like to provide more details about the specific issue you’re encountering so I can support you further?