Daily CSV Append to Google Sheet
Budget: ₹1,500 – ₹12,500 INR
Every day a system-generated CSV lands in my inbox as an email attachment. I need that file processed automatically so its new rows are appended to an existing Google Sheet without touching what is already there.
Key points
• Action: append only—no overwriting or deletions.
• Frequency: once per day, triggered as soon as the email arrives (or on a fixed daily schedule if that is simpler to maintain).
• Source: the attachment in a specific email thread or subject line.
• Destination: one worksheet inside my Google Sheet; column order matches the CSV header.
Deliverables
1. A working Google Apps Script, Make/Zapier scenario, or other cloud-based solution that runs unattended.
2. Clear setup notes so I can adjust the destination sheet ID or email filter later.
3. A quick demo showing today’s CSV successfully appended.
Acceptance criteria
• All rows from the latest attachment appear directly below the last filled row.
• No duplicate headers or skipped records.
• The job can be re-run without creating duplicates when the same file is encountered again.
If an Apps Script is chosen, please stick to the standard Google Workspace APIs; for third-party tools, ensure they require only free or low-tier plans. Looking forward to a neat, reliable automation.
Key points
• Action: append only—no overwriting or deletions.
• Frequency: once per day, triggered as soon as the email arrives (or on a fixed daily schedule if that is simpler to maintain).
• Source: the attachment in a specific email thread or subject line.
• Destination: one worksheet inside my Google Sheet; column order matches the CSV header.
Deliverables
1. A working Google Apps Script, Make/Zapier scenario, or other cloud-based solution that runs unattended.
2. Clear setup notes so I can adjust the destination sheet ID or email filter later.
3. A quick demo showing today’s CSV successfully appended.
Acceptance criteria
• All rows from the latest attachment appear directly below the last filled row.
• No duplicate headers or skipped records.
• The job can be re-run without creating duplicates when the same file is encountered again.
If an Apps Script is chosen, please stick to the standard Google Workspace APIs; for third-party tools, ensure they require only free or low-tier plans. Looking forward to a neat, reliable automation.