Email Lists and Excel
Greetings IH,
Is there a service out there that when a user subscribes to an email list, it get's added into an excel spreadsheet? Basically using excel as a database. I feel this is better then storing it in say MailChimp, since I have the asset with me. I don't need to worry about MailChimp doing anything crazy or shutting down (probably won't happen).
Well, the only problem with Excel, or any spreadsheet for that matter, is that it is a flat file system. CSVs are great for transporting data, but my recommendation is to store your data in a relational database.
Do email services allow for email list exports?
Yes, as does Mailchimp:
https://mailchimp.com/help/view-export-contacts/
Try Zapier.
Make sure your mailing list structure has clearly defined.
You can use one my of side-projects: https://LaunchSoon.net
You can setup it in minutes and emails are saved in a CSV file which you can easily import in any email platform
Please let me know if you have any questions or if you need any help
Hey dude, I’m actually working on something that does exactly this. (Google Sheets). It’s called SheetCapture. Check it out here; https://sheetcapture.com
It’s not finished yet so don’t expect it to work as of now. But the main concept is there and I have the API working... I just need to finish the main site and functionality. Is this something that would benefit you ?
My original niche idea was targeting “capturing email addresses” however I’ve since opened it up to target any sort of data capture.
It will literally be 3 simple steps. And I’m working on better USPS and features with video on the front page of the landing page.
Follow the project on indie hackers through my profile and I’ll keep you up to date.
I was experimenting with this last week. Since Excel is offline you can’t send new signups directly to Excel. You can however add a new row to a Google spreadsheet every time someone signs up.
The easiest way would be to connect Zapier to a Google Spreadsheet. If you are a little more advanced or a developer you can use the Google API.
I agree with your suggested approach, I used the Google API when setting up my wedding website to add RSVPs to a Google Sheet and it was easier than I thought it would be. Would recommend it!
This comment was deleted 7 years ago