Tips for Exporting Profile Pictures to Google Sheets or Notion

Hey! I am having trouble with exporting Profile Pictures. I would like to export them to either google sheets or Notion as actual photos, not links to downloadable photos. I have over 100 rows and am trying to create a 'facebook' for an event, so having to do this manually defeats the purpose of using Clay to get the photos in the first place! Any tips? I tried to export them into a Notion database as text and then converted the column into a file column, but it still just kept it as en embedded link and not the image itself

5 comments

Channeled
APP
·
·
Currently, when exporting profile pictures from Clay, you have two main options: 1. Export to CSV/Google Sheets: • You can export your data using the 'Actions' menu and clicking 'Download CSV' • Import this CSV into Google Sheets 2. Integration with Google Sheets: • You can set up a direct Google Sheets integration in Clay • Use the 'Add Row' action to send data directly to your Google SheetHowever, please note that profile pictures will export as URLs in both cases. To work with the actual images, you would need to use an intermediate service like Dynapictures, which can help transform URLs into actual images in your final destination.For the specific use case of creating a "facebook" for an event, you might want to consider using a different tool or platform that's better suited for image gallery creation, as both Google Sheets and Notion have limitations when it comes to displaying images from URLs automatically. Sources: Download as a CSV [Clay 101] - Clay University Google Sheets [Clay 101] - Clay University Dynapics - Custom Images Part 1 | Clay
Channeled
APP
·
·
Was that helpful?
Channeled
APP
·
·
Looks like you're still looking for help. We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Owen C.
·
·
Hey Lucy, thanks for reaching out. Would love to learn a bit more about the "facebook" for an event. Most softwares transfer images through a URL for ease and speed of data transfer. However, in Clay you can preview these as images. Wondering if there is a similar feature in the spot you're hoping to create this webhook. Would love to hear you're thoughts! :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1369033444/cafe43f04d1b3234ad68342470a7/CleanShot+2025-02-06+at+17_29_22%402x.png?expires=1738882800&signature=44879a44f7e41d68efc43eecd215c6f4986cbc331070d4c3dfc0589481cd07e0&req=dSMhH8l9noVbXfMW1HO4zRJI8ym5qIeKpcgTpTzb2f6PkoSDE77KJzXBSBzj%0A9l8U%0A
Channeled
APP
·
·
Hi Lucy B.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: