S-VISION · PRACTICAL OFFICE AUTOMATION

Google
Smart Office.നിങ്ങളുടെ ജോലിക്ക് അനുയോജ്യമായ ഓട്ടോമേഷൻ.

One useful workflow. One clear prompt.ഒരു workflow തിരഞ്ഞെടുക്കൂ. ഒറ്റ complete prompt Gemini-യിൽ നൽകൂ.

Choose your workflow ↓നിങ്ങളുടെ workflow തിരഞ്ഞെടുക്കുക

01 / YOUR STARTING POINT

Start safely.സുരക്ഷിതമായി തുടങ്ങാം.

Create a separate private native Google Sheet with fictional training records. Agree the fields first; keep existing files untouched.

വേറെ private native Sheet, fictional data മാത്രം. Fields ആദ്യം ഉറപ്പിക്കുക; പഴയ files മാറ്റരുത്.

02 / YOUR WORKFLOW

Choose a category.വിഭാഗം തിരഞ്ഞെടുക്കുക.

Plan names do not guarantee connected tools or autonomous deployment. No paid AI API is required for the core exercise.Plan പേര് കൊണ്ട് connected tools/deployment ഉറപ്പില്ല. Core exercise-ന് paid AI API വേണ്ട.

03 / UNDERSTAND THE RESULT

Know what you will build.എന്താണ് ഉണ്ടാക്കുന്നതെന്ന് മനസ്സിലാക്കാം.

Objective / ലക്ഷ്യം
Choose a workflow to see its goal.
Data flow / Data flow
Approved data → validation → reviewed result.
Prerequisites / തയ്യാറെടുപ്പ്
Confirm identity, fields, permissions and desired outputs before coding.
Practice / പരിശീലനം
Use only fictional records or approved private test copies.
Expected result & checks / ഫലം, പരിശോധന
Record actual PASS / FAIL / NOT TESTED, not assumed execution.

One complete English promptഒറ്റ complete English prompt

Copy into Gemini. Explain → verify access → build one stage → check evidence.Gemini-യിൽ നൽകുക. വിശദീകരണം → access → ഒരു stage → തെളിവ് പരിശോധിക്കുക.

Enable JavaScript to configure your prompt, or use the manual learning path below.
Open Gemini ↗Gemini തുറക്കുക

KEEP LEARNING

From first row to a working demo.ആദ്യ row മുതൽ പ്രവർത്തിക്കുന്ന demo വരെ.

The existing RP Smart Office learning path remains available: two routes, 30 verified stages each, and all Session 2–4 exercises. Its fixed RP dummy schema is a separate reference, not a template to overwrite an existing source.

പഴയ RP learning path ലഭ്യമാണ്: രണ്ട് routes, ഓരോന്നിലും 30 stages, Session 2–4 exercises. RP dummy schema വേറെ reference ആണ്; existing source overwrite ചെയ്യാനുള്ള template അല്ല.

Open stepwise learning path ↗Stepwise learning path തുറക്കുക

Database → entry form → stored row → Admin/modules → controlled automation → dashboard design last.

Database → entry form → stored row → Admin/modules → controlled automation → dashboard design അവസാനം.

Browse every workflow without JavaScript / എല്ലാ workflows വായിക്കാം

Dashboards & reportingDashboard, reporting

Understand verified trends and decisions from actual approved rows.

  • Fictional sales overview / സാങ്കൽപ്പിക sales overview — Group sales by month/status; compare chart totals with ten dummy rows.
  • Fictional programme report / സാങ്കൽപ്പിക programme report — Compare registration versus recorded attendance counts without equating them.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Reconcile totals to source rows; test filter combinations, empty states, keyboard/mobile access; no fabricated statistics.

Official reference ↗

CRM & enquiriesCRM, enquiries

Track reviewed enquiries and follow-ups without exposing private records.

  • Fictional services lead tracker / സാങ്കൽപ്പിക services lead tracker — Record a sample enquiry, assign an owner and move stage after a confirmed save.
  • Fictional student support desk / സാങ്കൽപ്പിക student support desk — Link two support tickets to one dummy StudentID; do not merge on name.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Create/edit/search dummy records, preserve stable links, reject unauthorized edits and false success; duplicate phone is not identity.

Official reference ↗

Interactive formsInteractive forms

Accept a validated entry once and prove it becomes a stored record.

  • Fictional entrepreneur registration / സാങ്കൽപ്പിക entrepreneur registration — Use normalized Udyam as the unique enterprise master key while retaining stable BusinessID and separate PersonID contacts. Review the cross-programme attendance policy before enabling it.
  • Fictional student registration / സാങ്കൽപ്പിക student registration — Use approved StudentID plus CourseID for same-course registration checks. No entrepreneur attendance restriction applies.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Test missing/invalid input, repeated RequestID, same-programme duplicate, distinct programme eligibility, concurrent equivalent identities, failed saves and no private lookup leaks.

Official reference ↗

Data cleaning & duplicate reviewData cleaning, duplicate review

Find data issues without silently changing or merging source records.

  • Fictional contact-quality audit / സാങ്കൽപ്പിക contacts audit — Report blank IDs, malformed email and candidate duplicate mobile values; never merge different people automatically.
  • Fictional student roster audit / സാങ്കൽപ്പിക student roster audit — Flag duplicate StudentIDs, invalid dates and unknown ClassIDs without deleting rows.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Compare audit counts twice; flag duplicate keys/orphans, formulas and ambiguous matches; preserve leading zeros and formulas.

Official reference ↗

CSV import, export & consolidationCSV import, export, consolidation

Preview imports and safely consolidate approved CSV data.

  • Fictional monthly sales consolidation / സാങ്കൽപ്പിക monthly sales consolidation — Preview two dummy monthly CSVs; reimport the same content under a renamed file without duplicating it.
  • Fictional membership list import / സാങ്കൽപ്പിക membership list import — Map differently named headers into a staged preview and require approval for conflicts.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Test UTF-8/BOM, quoted commas/newlines, repeated file/content hash, partial retry, key conflicts and formula-safe exports; reconcile accepted/rejected totals.

Official reference ↗

Documents & PDF generatorDocuments, PDF generator

Create one private document from an approved template and selected record.

  • Fictional service quotation / സാങ്കൽപ്പിക service quotation — Preview line totals; copy a private quotation template and optionally export PDF without sending.
  • Fictional attendance certificate / സാങ്കൽപ്പിക attendance certificate — Generate only for a dummy record with explicit verified attendance, not merely registration.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Verify placeholders, literal special characters, record ID, totals, private sharing, retry reuse and source/template preservation. No tax compliance claim.

Official reference ↗

Email automationEmail automation

Preview safe notifications before approved delivery.

  • Fictional weekly enquiry digest / സാങ്കൽപ്പിക weekly enquiry digest — Preview aggregate weekly counts and a self-addressed email before any approved send.
  • Fictional appointment follow-up / സാങ്കൽപ്പിക appointment follow-up — Prepare an owner-reviewed follow-up draft, with no automatic sending.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Test dry run, missing address, one self-send, deduplicated retry, failure and uncertain-send reconciliation. Do not promise exactly-once email delivery.

Official reference ↗

Presentation generatorPresentation generator

Populate an approved Slides template from verified report data.

  • Fictional monthly operations deck / സാങ്കൽപ്പിക monthly operations deck — Fill a five-slide status template with verified dummy totals; never invent performance.
  • Fictional project update deck / സാങ്കൽപ്പിക project update deck — Produce an agenda, milestones, risks and next actions from approved project rows.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Compare slide numbers with reports; verify overflow, readable charts, missing placeholders, private access and rerun behaviour.

Official reference ↗

Deadlines & follow-upDeadlines, follow-up

Show due work and preview controlled reminders.

  • Fictional licence renewal tracker / സാങ്കൽപ്പിക licence renewal tracker — Show renewals due within 30 days using fictional dates and preview reminders.
  • Fictional seven-day enquiry follow-up / സാങ്കൽപ്പിക seven-day follow-up — Use an owner-confirmed seven-day age rule for open enquiries without changing the source schema.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Test before/on/after deadline, timezone boundaries, missing dates, retry, quota and disabled training trigger. Do not invent a DueDate field.

Official reference ↗

Approvals & request trackingApprovals, request tracking

Track authorized human decisions with an audit trail.

  • Fictional leave requests / സാങ്കൽപ്പിക leave requests — Submit a dummy leave request; an authenticated authorized reviewer explicitly approves/rejects.
  • Fictional purchase requests / സാങ്കൽപ്പിക purchase requests — Preview a purchase request and record the authorized decision; do not place an order or pay.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Test unauthorized decisions, stale/concurrent decisions, rejection/resubmission and immutable history. The AI never approves requests itself.

Official reference ↗

Meetings & tasksMeetings, tasks

Turn reviewed meeting notes into accountable tasks.

  • Fictional team meeting actions / സാങ്കൽപ്പിക team meeting actions — Use dummy meeting notes to draft an agenda and reviewed action table.
  • Fictional project milestone meeting / സാങ്കൽപ്പിക project milestone meeting — Compare decisions with milestone rows; leave unknown deadlines Missing.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Flag missing owners/dates instead of guessing; test duplicate task retry and permissions. Creating calendar events or sending invites needs separate explicit approval.

Official reference ↗

Onboarding checklistOnboarding checklist

Prepare a private reviewed checklist for a new person or project.

  • Fictional employee onboarding / സാങ്കൽപ്പിക employee onboarding — Draft a first-week checklist and private template plan; no real employee data.
  • Fictional client project onboarding / സാങ്കൽപ്പിക project onboarding — Prepare a kickoff checklist and approved document/folder preview for a fictional project.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Verify task ownership, required versus optional items, rerun identity and private outputs. No automatic account creation, access grants or welcome sends.

Official reference ↗

Drive files & foldersDrive files, folders

Organize private project files without destructive moves or public sharing.

  • Fictional client project folders / സാങ്കൽപ്പിക client folders — Preview one client folder with approved template copies; use actual IDs rather than names alone.
  • Fictional course materials organiser / സാങ്കൽപ്പിക course files organiser — Propose a course/module structure and verify a private test copy without moving live originals.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Test duplicate folder names, ambiguous IDs, inherited sharing, repeated runs and missing templates. Preview renames/moves; do not trash or overwrite files.

Official reference ↗

Inventory & assetsInventory, assets

Track reviewed stock movements and asset custody.

  • Fictional shop stock ledger / സാങ്കൽപ്പിക shop stock ledger — Record dummy receipts/issues and reconcile running balance; coordinate concurrent writes.
  • Fictional office asset register / സാങ്കൽപ്പിക office asset register — Track one dummy laptop issue/return with an immutable custody history.
  • Custom — your own workflow / Custom — സ്വന്തം workflow — Ask for the missing requirements one question at a time; confirm an English requirements summary before any code.

Check: Test duplicate movement IDs, concurrent issues, negative-stock policy, returns, reconciliation and audit preservation. No automatic purchasing/payment.

Official reference ↗

Use the current official guidance.Current official guidance പരിശോധിക്കുക.

Checked 4 November 2026. Capabilities and quotas can change; verify your actual account before acting.

Gemini in Sheets capabilities ↗Apps Script quotas ↗Lock scope ↗Official Udyam portal ↗

This is an independent S-Vision training guide. Format checks are not government verification; organizer eligibility policies are not government rules.

Chat on WhatsApp