
Closed
Posted
Every day new messages land in my Gmail inbox and I need only one field from each of them—the sender’s email address—captured in Excel. Each message should occupy a separate row so I can sort, filter, and run simple counts without any extra cleanup. I’m looking for a small, self-running workflow that: • Connects to my Gmail account, scans all new incoming mail on a daily basis (time of day is flexible). • Pulls just the sender’s email address from each message. • Appends that address to an existing or newly created .xlsx file, placing each email on its own row in chronological order. You’re free to choose the most efficient approach—Google Apps Script, a lightweight Python script using the Gmail API, or another proven method—as long as it runs reliably in the background and doesn’t require me to click anything once it’s set up. Deliverables 1. Working script or automation with clear setup instructions. 2. A test Excel file showing the captured addresses for demonstration. 3. Brief documentation explaining how to adjust the date range or change the output file path in the future. Once everything is tested and I can see one day’s worth of senders appear in Excel automatically, the job is done.
Project ID: 40664258
63 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
63 freelancers are bidding on average $6 USD/hour for this job

As a seasoned data professional, I possess the exact skills and expertise required for your Extract Gmail Senders to Excel project. My team at BN-Droids has an impressive track record of automating repetitive tasks just like yours. We've safely navigated complex email APIs before and condensed raw info into clean Excel rows, ensuring easy manipulation or data analysis. Our scripts have successfully sifted through millions of records daily with high accuracy, which greatly aligns with your needs.
$3 USD in 40 days
7.0
7.0

Hello, I’m an experienced Google Apps Script developer specializing in reliable Google Workspace automation. I can build a self-running workflow that connects securely to your Gmail account, scans all messages during the initial setup, and processes only new incoming messages during subsequent scheduled runs. The script will extract only each sender’s email address and append one address per row to an existing or newly created Excel (.xlsx) file. Messages will be recorded in chronological order without any duplicates, with no manual cleanup required. I’ll configure a daily time-based trigger so the workflow runs automatically in the background. I’ll provide the completed script, clear setup instructions, a test Excel file containing sample results, and brief documentation explaining how to adjust the date range, schedule, and output file location. A Settings sheet will make future configuration simple, including the date range and Google Drive path. Before delivery, I’ll test the automation with one day of messages and confirm that the sender addresses appear correctly in Excel. Let's discuss your project with me.
$5 USD in 40 days
6.6
6.6

Hi, I'm Denis, a developer who has set up similar Gmail-to-Excel automations before. I understand you need a reliable daily process that quietly pulls sender emails from new Gmail messages and saves them into an Excel file without any manual steps after setup. The core challenge is keeping the extraction light, the cron job simple, and the output clean so you can sort and count addresses immediately. I would approach this with a Python script using the Gmail API and openpyxl for Excel handling. The script would authenticate once, fetch only unread messages from the last 24 hours, extract the sender address from the header, append it to the bottom of the existing sheet, and mark messages as read so they don’t get processed again. A lightweight cron job or scheduled Cloud Function would trigger the script each morning. I’d include a small config file for adjusting date windows or file paths and deliver a test run so you can see the first batch land in Excel automatically. One real risk is Gmail API rate limits—we’ll use batch requests and exponential backoff to stay within quotas without over-engineering. Another is label management; we’ll make sure the script only looks at new mail, so old messages don’t reappear. I can start working right away. Let's connect and discuss the details. Thanks, Denis.
$2 USD in 40 days
6.1
6.1

★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★Linkedin★ ★Data Entry★ ★Business Plans★★★ ★★★ Operational Strategic planner Customer Support 24*7★★★ ★★★Excel/Word Operation★★★ ★★★Chat Support★★★ ★★★Calling Support★★★ ★★★Business Plans / Marketing Strategy ★★★ * Digital Marketing★★★ ★★★Social Media Marketing ★★★ ★★★Internet Marketing ★★★ ★★★Any type of Data Projects★★★ ★★★★★★ Regards, ★★★CMD★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN I CAN★★★
$2 USD in 40 days
6.2
6.2

Hi, I can build this as a simple Python + Gmail API automation that runs in the background without requiring daily manual work. It will check new emails, extract only the sender’s email address, and add each address to an Excel file in chronological order. I’ll handle the Gmail authentication, Excel updates, date filtering, duplicate handling, and scheduling. I’ll also provide a test Excel file and clear instructions for changing the date range or output location. Best regards, Soufiane
$6 USD in 40 days
5.7
5.7

Hello, I can build a reliable Gmail-to-Excel automation that captures sender email addresses daily, appends each to a separate row, and runs automatically without manual input. I’ll provide the working script, test Excel file, setup instructions, and brief documentation for future adjustments. Regards Muhammad
$5 USD in 40 days
5.8
5.8

As a seasoned developer with a strong passion for automation, I am confident that I can create an elegant and reliable solution to address your needs. My experience with Python and Google APIs, specifically the Gmail API, makes me the perfect fit for this project. I have successfully developed several workflows similar to yours in the past, capturing specific data from emails and storing them efficiently in Excel. Not only will I provide you with an effective script to automatically extract the sender's email addresses from your Gmail inbox to an Excel file, but I'll also document it in a way that allows easy management of date ranges or output file paths. Additionally, throughout my work, I emphasize clean code, scalability, and long-term usability – an approach that perfectly aligns with your requirement for a self-sustaining workflow. Furthermore, my extensive background in automation extends beyond just Python; I'm also familiar with tools like n8n. This means I am well-equipped to choose the most efficient path suited to your unique requirements while ensuring a seamless experience for you. Let's embark on this project together and create a workflow that not only captures pertinent data but also empowers you to analyze and understand your email landscape better!
$5 USD in 40 days
5.3
5.3

Hello, I’ve understood your requirement for an automated Gmail workflow that extracts sender email addresses and continuously appends them to an Excel file. I’m a strong fit with experience in Python automation, Gmail API, Excel processing, and background workflows. I can make it reliable, simple to maintain, and fully automated after setup. Let’s discuss the exact setup and get it done quickly. Best regards, Jaibhan Singh Gaur
$3 USD in 10 days
5.5
5.5

Automating daily mail sender extraction requires a background script using Python with the official mail API and OpenPyXL to pull incoming headers chronologically without manual intervention. I will build a lightweight Python automation script that authenticates securely via OAuth, extracts target sender email addresses from new messages, appends them directly to your .xlsx workbook, and includes step-by-step setup documentation alongside a test Excel file. Do you prefer setting this up via a local Python Task Scheduler/Cron job or running it directly inside Google Sheets using Google Apps Script? I’ve engineered custom API automation and file processing Python scripts before and can deliver the full script, documentation, and test Excel file; please let me know your preferred setup approach so we can finalize the script logic right away.
$6 USD in 4 days
4.7
4.7

Hello, I’d be happy to build this fully automated Gmail → Excel workflow. I can create a lightweight solution using Google Apps Script or the Gmail API, depending on your preferred setup. The workflow will: * Automatically scan new Gmail messages each day. * Extract only the sender’s email address. * Append each address as a separate row in an .xlsx file. * Keep entries in chronological order. * Avoid duplicate processing of previously captured emails. * Run automatically in the background without daily manual input. * Include clear setup and maintenance instructions. I’ll also provide: 1. The complete working script/automation. 2. A test Excel file demonstrating the output. 3. Brief documentation explaining how to change the date range, output location, and schedule. I’ll test the workflow with a sample day and make sure the captured addresses match the Gmail messages before delivery. Best regards.
$5 USD in 70 days
4.9
4.9

Hi, your goal is clear: capture only the sender’s email from each new Gmail message and append it to Excel automatically, one row per message. I can set this up as a reliable background workflow with either Google Apps Script or a lightweight Python/Gmail API solution, depending on what will be easiest for your setup. I’ve built similar automations that pull data from Gmail, process new mail on a schedule, and write clean .xlsx output without manual steps. I’d make sure the file is created or updated safely, the rows stay chronological, and the script only processes new messages each day. I’ll also include a test Excel file and short instructions for changing the date range or output path later. If you’d like, I can get this working quickly and keep the setup simple. Best regards, Gabriel
$25 USD in 30 days
4.6
4.6

Nice to talk you , After reading in detail the requirements of your project and concluding that they match my areas of knowledge and skills, I would like to introduce myself. My name is Anthony Muñoz and I am the lead engineer for DS Pro IT agency. I have worked for over 10 years in Backend and software development and have successfully done multiple jobs. It will be a pleasure to work together to make your project a reality. Please feel free to contact me. I´m looking forward to working with you. I really appreciate your time and remain attentive to any request or question. Greetings
$6 USD in 40 days
4.6
4.6

I can build a reliable Gmail-to-Excel automation that runs automatically in the background and requires no daily manual work. I have strong experience with Python, APIs, Google services, automation workflows, data processing, and Excel-compatible outputs. My recommended approach is a lightweight Python script using the Gmail API, scheduled through a server/Task Scheduler/cron job. It will authenticate securely with Gmail, identify incoming messages within the required time range, extract only the sender’s email address, and append each sender as a separate row in an existing or newly created ".xlsx" file. Messages will remain in chronological order, making the file immediately usable for sorting, filtering, and counting. I will also handle duplicate senders according to your preference—for example, retaining every email as a separate row if the same person sends multiple messages. The workflow can be configured to process only new messages, unread messages, or all messages within a specified date range.
$2 USD in 40 days
4.7
4.7

Hello You need a simple automated workflow that checks Gmail daily, extracts only sender email addresses, and adds each address to an Excel file in chronological order without manual work. I can build this using Google Apps Script or Python with the Gmail API, including duplicate-safe processing, automatic scheduling, Excel export, and clear setup documentation. I’ll also provide a sample Excel file and ensure the workflow is tested end-to-end. I can start immediately. Best Regards Fizza
$2 USD in 40 days
4.4
4.4

I can set this up so every new Gmail message is checked automatically, the sender’s email is pulled out, and added to your Excel file one per row. I’ll handle the script, testing, sample Excel, and setup guide—once it’s running, you won’t need to touch it. Send me a message and I’ll get started.
$3 USD in 40 days
3.9
3.9

Gmail API with a service account and a daily Cloud Scheduler trigger is more reliable than Apps Script here, since Apps Script has a 6-minute runtime cap and can silently skip large inbox days. I'll wire a Python job that pulls sender addresses from new mail, appends each to your .xlsx via openpyxl, and logs the last processed message ID so nothing duplicates or gets missed. 1) Should the sender be the raw email only, or name plus address in two columns? 2) Do you want the .xlsx on Google Drive, or on a local machine that stays on? Cheers Shayan
$5 USD in 40 days
3.6
3.6

Hi, My name is Plabon Gupta, and I’ve carefully read your project description. I’ve completed several similar projects recently and bring over 3 years of full-time experience as a Virtual Assistant. I am skilled in Manual Data Entry/Collection web scraping, web search, data scraping, data mining, website product upload, email list building, handwriting note or photo to pdf, excel, pdf to excel/word conversion, pdf editing & compression, copy paste, fast & accurate typing, web research, reddit forget, translation in any language, graphics design (photoshop, illustrator, powerpoint) etc. I’m committed to delivering excellent results on time, ensuring 100% satisfaction with every task. Plz communicate with me for more discussion. Looking forward to your response! Best regards, Plabon Gupta
$3 USD in 40 days
3.6
3.6

✅ I will build a self‑running daily workflow that connects to your Gmail inbox, scans new messages, extracts sender email addresses, and appends them to an Excel (.xlsx) file – one per row, in chronological order. I recommend using Google Apps Script (native, no external setup) or a Python script with the Gmail API (more flexible). Both run reliably in the background. Deliverables: working script, setup instructions, test Excel file, and documentation for adjusting date range/output path. **Question:** Do you have a preferred method (Google Apps Script vs Python), and should the script process only new unread messages or all messages from the last 24 hours? Best, Usman K https://www.freelancer.com/u/ukokab
$3 USD in 40 days
3.7
3.7

Hi there, A daily Gmail-to-Excel workflow can become unreliable if messages are skipped, duplicated, or appended out of order. I’ll build a small automated process that scans new mail, extracts only sender addresses, appends them chronologically to Excel, and includes clear setup and adjustment instructions. I’ll also validate it with a test workbook so you can confirm one full day of results. I have two quick questions to make sure we're on the same page: 1. Should repeat senders be added for every message or stored only once? 2. Where should the Excel file run and be saved: locally or in cloud storage? Let’s discuss your project now!
$2 USD in 10 days
3.4
3.4

Hello, I’ve built small background automations around Gmail APIs and spreadsheet exports, so this is a straightforward workflow where reliability and avoiding duplicate entries matter more than adding unnecessary complexity. One question first: should the automation process only emails received after the last successful run, or do you want a configurable date range for every run? I’d use Google Apps Script with the Gmail API so the workflow can run automatically on a schedule without requiring a separate server. It would identify newly received messages, extract only the sender address, check the existing sheet to avoid duplicates where needed, and append each address in chronological order. I’d keep the output compatible with Excel and provide the initial .xlsx example as requested. The setup notes would also explain how to change the date range, schedule, and output location later. I can keep this lightweight and easy to maintain. Abel
$5 USD in 40 days
2.9
2.9

Orani, Philippines
Member since Jul 4, 2024
$10-50 USD
$250-750 USD
$50-70 USD
$2-8 USD / hour
$250-750 USD
$8-15 USD / hour
$30-250 USD
₹750-1250 INR / hour
$30-250 USD
$30-250 NZD
₹37500-75000 INR
$15-25 USD / hour
$2-8 USD / hour
$30-250 CAD
$30-250 USD
$10-30 USD
$30-250 AUD
$30-250 USD
$15-25 USD / hour
$30-250 AUD