Scribd
Upload
11 views4 pages

AppScript 40 Blocks

The document outlines 40 upgraded building blocks for App Script, each designed to perform specific tasks such as extracting unread emails, validating sheet rows, syncing events to Google Calendar, and generating documents. Each building block specifies the input required and the output it returns, facilitating various automation and data handling processes. These tools enhance productivity by streamlining workflows and integrating with external APIs.

Uploaded by

mrnaitikd97
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views4 pages

AppScript 40 Blocks

The document outlines 40 upgraded building blocks for App Script, each designed to perform specific tasks such as extracting unread emails, validating sheet rows, syncing events to Google Calendar, and generating documents. Each building block specifies the input required and the output it returns, facilitating various automation and data handling processes. These tools enhance productivity by streamlining workflows and integrating with external APIs.

Uploaded by

mrnaitikd97
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

App Script Upgraded Building Blocks

Upgraded App Script Building Blocks (40 Items)

1. Unread Email Extractor


Input: none or Gmail query
Returns: unread email objects

2. Sheet Row Validator using External API


Input: sheet row values
Returns: validation response

3. External Event Sync to Google Calendar


Input: event data from API
Returns: event IDs

4. API to Sheet Table Writer


Input: JSON API URL
Returns: written table

5. Smart Webhook Sender


Input: sheet row or form submission
Returns: API response

6. Form Response Enricher


Input: form event
Returns: enriched fields

7. Daily API Fetch Trigger


Input: time trigger
Returns: updated sheet and email

8. Auto Document Generator


Input: template + variables
Returns: doc or PDF link

9. Custom Menu Workflow Runner


Input: menu click
Returns: workflow result

10. File Downloader to Drive


Input: file URL
Returns: Drive file link

11. Smart Alert System


Input: sheet condition
Returns: Slack or WhatsApp alert

12. External Translation Block


Input: text
Returns: translated text

13. AI Text Analyzer


Input: paragraph
Returns: summary and sentiment

14. OCR Image Text Extractor


Input: image URL
Returns: extracted text

15. Address to Coordinates Converter


Input: address string
Returns: lat-long

16. Auto Duplicate Row Cleaner


Input: sheet data
Returns: cleaned sheet

17. Email Auto-Tagger


Input: unread emails
Returns: applied label

18. Sheet Row Auto-Formatter


Input: new row
Returns: formatted sheet

19. Expiry Reminder Generator


Input: date column
Returns: reminder email

20. Missing Data Highlighter


Input: sheet values
Returns: highlighted blanks

21. URL Metadata Fetcher


Input: URL
Returns: title and description

22. SMS Sender


Input: phone and message
Returns: SMS status

23. Auto Backup to Drive


Input: sheet
Returns: backup file

24. File Type Sorter


Input: folder files
Returns: organized folders

25. Dropdown Generator


Input: list items
Returns: data validation dropdown

26. Currency Converter


Input: amount + currency
Returns: converted amount

27. Contact Sync to Google Contacts


Input: contact info
Returns: created contact

28. Auto Number Generator


Input: new row
Returns: unique ID

29. Dashboard Snapshot Emailer


Input: chart or sheet
Returns: emailed snapshot

30. Spellcheck and Grammar Checker


Input: text
Returns: corrected version

31. Project Deadline Tracker


Input: task table
Returns: late task alerts
32. Auto-PDF Generator for Each Row
Input: row data
Returns: PDF file link

33. WhatsApp Notification Sender


Input: phone and message
Returns: WhatsApp message status

34. Address Auto-Corrector


Input: address
Returns: corrected address

35. Lead Source Classifier


Input: text or URL
Returns: lead category

36. Image Auto-Resizer


Input: Drive image
Returns: resized image

37. Auto Delete Old Files


Input: folder + days
Returns: deletion summary

38. PDF Text Extractor


Input: PDF
Returns: extracted content

39. Sheet Change Logger


Input: edit event
Returns: log entry

40. Email Bounce Detector


Input: email threads
Returns: bounced list

You might also like