Read data from Google Sheets and turn it into a Google Docs report. The workflow covers creating the document, writing report sections, and granting a stakeholder permission to read the finished file.
Read data from a Google Sheet and create a formatted Google Docs report.
Review the instructions the agent will receive before you install.
PREREQUISITE: Load the following skills to execute this recipe:
gws-sheets,gws-docs,gws-drive
Read data from a Google Sheet and create a formatted Google Docs report.
gws sheets +read --spreadsheet SHEET_ID --range "Sales!A1:D"gws docs documents create --json '{"title": "Sales Report - January 2025"}'Total deals: 45 Revenue: $125,000
gws drive permissions create --params '{"fileId": "DOC_ID"}' --json '{"role": "reader", "type": "user", "emailAddress": "cfo@company.com"}'No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Retrieve Google Workspace audit logs, which record account activity, and usage reports through gws. Review activity in applications such as the Admin console and Google Drive, or inspect statistics for the organization, users, and entities.
Manage Google Calendar events and calendars, including creating, updating, and deleting events. View upcoming events across calendars, check availability, and manage the permissions that control who can access a calendar.
View upcoming Google Calendar events across all calendars in one agenda. Check today, tomorrow, this week, or a chosen number of days, with options to filter calendars and change the display time zone.
Create a Google Calendar event with a title and start and end times. You can also choose a calendar, add a location and description, invite attendees, and include a Google Meet link.
Manage Google Chat spaces, the places where conversations happen, and their messages through the gws command-line tool. Create or update spaces, add members, send messages, and upload or download attachments.
Send plain text messages to a specified Google Chat space using the gws command line tool. Use it for team updates and announcements, with guidance on finding space identifiers and confirming messages before sending.