Keep your entire team up to date on the latest metrics. Email daily KPI updates to your team based on data in a Google Sheet.
This automation will automatically email KPIs daily to your team after fetching the latest data from Google Sheets or another data source.
Once per day pull the latest records from a Google sheet
The latest KPI values are evaluated in the Lido spreadsheet
Send an email to your internal team using Gmail or Outlook:
SENDGMAIL(<gmail credential>,"my@email.com","Today's KPI's","Total Sales: & B6 )