Joe A.

Is there a way to push data from a google sheet into Clay without importing as a CSV? Or what are the most efficient ways to import from Google sheet to clay table? My use case is that I have prospect lists in a google sheet and I want to enrich with Clay data. However, every time I want to do that right now I have to export a new CSV and add it to a clay table. Any ways to streamline this?

I want to change the location data for people that returns as "{{city}} area" into three columns which are "city", "state", and "country". For example I'd like "greater tampa bay area" to be "Tampa, Florida, United States". The use case is segmenting a call list by time zone in outreach. Anyone done this before?

When I find people based on a list of companies I'm seeing quite a few people that used to work at the companies but no longer do. Some for >12 months. How can I remove these false results from people searches?