Ask Janek AI with Janek

All questions

Write Cold Emails & Icebreakers with AI (Using Make.com) · published 7 October 2025

Play at 0:01 Watch on YouTube Leads

How do I get an Apify lead file into Google Sheets for Make.com?

I delete every lead that has no email, upload the Excel to Google Drive, and open it as a Google Sheet. Make does not see the Excel file.

This is the export from the previous Apify video. I sort by email. This file has 32 leads with an address. I delete the rest instead of paying a tool to find the missing ones. A paid Apify run would leave more rows with emails. I also drop columns I do not need, save, and upload to Drive. I open it and save as Google Sheets, then I delete the Excel. At the end of the sheet I add two columns, icebreaker and email.