Hey guys, I want to build an auto reply system for my cold email campaigns.
Of course I will need a database with some information. I was thinking of just using google sheets or google docs, but after watching Jay's n8n masterclass, I discovered vector databses like supabase.
The thing is tho, I don't really see how is this different from airtable or spreadsheet other than the api limits which I never hit so far.
My questions are:
1) When do you actually need to use a vector database?
2) Is there reaaaally any significat difference, if so what is it? Am I missing anything?
3) What would be the best setup for an auto cold emailing system - do I just add some example conversations and prompts, or do I keep on adding all email communications to the vector databse in an automated way so it can MAYBE keep on improving on its own or...?
My original plan was to give the AI Agent access to perplexity so it can research the prospect and then save it in google sheets so it doesn't need to researche very time + give access to transcripts from the calls that I transcribe with fireflies ai, which would be used to have a lot of context so I can automate my follow ups.
What's the best setup to setting up a cold emailing system? Do I need a vector database there at all?
I would love to learn a lot more about this, feel free to reccomend a video or a good resource that would be relevant for this context.
Thank you in advance so much for your help.
Jan Lisy