Unfortunately not everyone will accept a guest post.
Some people will ignore your emails, or just never respond.
Don't expect to get replies from everyone.
Only a fraction of the people you reach out to will accept a guest post, and there may be a bit of emailing back and forth. This is why I will pay you a submission fee.
Also, YOU ONLY HAVE ONE SHOT to create a first impression. We have a limited amount of sites to contact, so the outreach email needs to be good. We don't want to waste opportunities because our outreach emails sucked and just got deleted.
So after you visit the page from the spreadsheet which you will get access to, you will read their submission guidelines and submit an article, or you will need to write an initial email to make a first contact.
You can certainly use a similar style for your outreach email, but you will need to tweak the email a bit and personalize it to the person you're reaching out to.
People do not want to read an email that looks like it's from a template.
So it needs to be personalized.
Always follow up, but I would suggest you just follow up 1 time.
Here is a guide on this which might help (#5, 6 and 9 are relevant):