How to Use Write to Table in Clay - Creating Individual Rows When Multiple Prospects are Found
Write-to-table is an essential tool when dealing with a large amount of data. In this SEO-optimized guide, you will learn how to utilize this tool to transfer and organize data effectively. The guide will walk you through how to write a list of objects from one table to another, using a practical example of contact and company information.
Step 1: Identify What You Are Writing
The first step in utilizing the Write-to-table tool is to identify the data you want to transfer. In our example, we're dealing with a list of objects, specifically LinkedIn matches.
Step 2: Visualize Your Target Table
Before you begin the process, visualize what your target table should look like. In our example, the ideal table contains all the columns about the company, along with the person's name, title, and LinkedIn profile that the LinkedIn Find people integration found.
Step 3: Create Your Target Table
The easiest way to create your target table is to export your source table as a CSV file and upload that table into your new location. Then, delete all the old information, leaving a carbon copy of the columns. In our example, we added columns for contact name, contact title, and contact LinkedIn profile.
Step 4: Begin Mapping the Columns
Choose to write a list of objects, then begin mapping the different columns. The Write-to-table tool will ask you if the value of each field is a constant or not. A value is constant if it's the same for all objects in your list.
Step 5: Map Constants and Variables
If a value is constant, map it by using the token. In our case, the company's founding date and total funding are constants. However, for values that vary like the prospect's name, title, and LinkedIn profile, type out exactly what the name is instead of using the token.
Step 6: Finalize and Save Changes
After mapping all constants and variables, check your entries, save the changes, and run the process. Refresh your table, and you should start seeing your new table populated with organized information.
You have now successfully used Write-to-table to map contacts and company information. This guide aims to help you use this tool more effectively, but if you have further questions, don't hesitate to reach out to the community on Slack.