Zapier allows users to maintain real-time activity logs in Google Sheets. When a sales tool or email platform fires a webhook indicating a lead interaction, Zapier captures the lead's email address. The workflow first searches the Google Sheet to find the row matching that email. Then, using the Update Spreadsheet Row action, it inserts the current date and time into the 'Last Contacted' column. This simple but critical automation provides a live view of sales activity, helping managers see who has been worked and who is being neglected.
Last verified: 1/14/2026
Sources:
Knowledge provided by Answers.org.
If any information on this page is erroneous, please contact hello@answers.org.
Answers.org content is verified by brands themselves. If you're a brand owner and want to claim your page, please click here.