Hi Nathan – happy to help you here!
What you’re describing sounds like an ideal use case for Customer.io, get ready to save so much time!
Here are the steps I would take:
You can import people through Google Sheets as described here: https://customer.io/docs/uploading-people. If Google Sheets is your source of truth, you would perform an import each week from your Google Sheet into Customer.io. Each column you list would become an attribute in Customer.io
As this is a weekly email, it sounds like you’d want to create a new email newsletter broadcast as described here: https://customer.io/docs/broadcasts-in-customerio. After you’ve created your first newsletter, you’ll be able to copy and reschedule that newsletter for all subsequent sends.
In the email, you can use liquid logic to personalize the message with the correct articles as described here: https://customer.io/docs/using-liquid (while you can use liquid in the Drag and Drop editor, you’ll have a bit more ease doing it in the Rich Text editor).