How to Connect an Author's Contact Form to a Reader-Tracking Spreadsheet
Short answer: connect your form (Google Forms, Typeform, or your own site's form) to a Make scenario that adds each response as a new row in Google Sheets, with date, name, email, and message. That way you have a history of every reader who's written to you, without digging through your inbox.
Why this is worth doing
When a reader writes to you with a question, a compliment, or a request for a sample chapter, that contact is valuable — but if it only lives in your email, it gets lost among everything else. Having every contact in one sheet lets you, for example, notify them first when you publish a new book.
How to set it up
Create your form in Google Forms (it's free and integrates directly with Sheets).
In Make, use the "New form response" trigger from Google Forms.
Connect the output to a Google Sheets module that adds a row with the form's fields.
Optional: add a third step that sends you a notification (Telegram, Slack, or email) every time a new response comes in.
If you use Google Forms connected directly to Google Sheets (without Make), that integration is native and free — Make only adds value once you want extra steps, like a notification or an automatic reply.
Source: official Google Forms documentation, 2026