google-sheets

2 posts

kakao

Is a Non-Developer Who Does Vibe Coding a Developer? (3) (opens in new tab)

AI coding agents have helped a non-developer move from creating small local HTML tools to building shared dashboards, integrations, automations, and repeatable workflows. The major change was not writing more code, but learning to define data, permissions, inputs, outputs, exceptions, and validation criteria. The author concludes that AI is making more kinds of work executable and structured, expanding questions about “development” beyond professional developers. ## From Local HTML to Shared Tools - Early tools were standalone HTML files used locally in a browser. - Sharing them introduced deployment, URLs, version updates, and maintenance concerns. - Once users needed persistent data and changing states, the problem expanded from UI design to: - Data storage - Access and edit permissions - Change history and rollback - Backups and operational responsibility - Google Sheets became a practical lightweight database because it already provided: - Collaboration and familiar interfaces - Permission management - Revision history - The author progressed from manually pasting Apps Script code to using `clasp` and Apps Script APIs for deployment and execution. - The key shift was learning to evaluate where data should live and which tools already work safely within an organization. ## Security as a Daily Habit - Connecting work tools through webhooks introduced the need to protect tokens and webhook URLs. - The author began using `.env` files and `.gitignore` to prevent secrets from entering source code or Git repositories. - Requests to AI agents increasingly included security requirements: - Read secrets from environment variables - Avoid printing sensitive values in logs - Use placeholders instead of real credentials - Small automations connected to external systems naturally required thinking about secret management, execution environments, and access control. ## Turning Manual Tasks into Workflows - Tasks such as copying files, organizing folders, converting documents, editing videos, and extracting audio or summaries were delegated to AI agents. - Delegating these tasks required explicit definitions of: - Input files - Output names and formats - Whether existing files may be overwritten - Failure conditions - Verification requirements - Informal, intuitive actions became structured work specifications. - The author found that understanding completion criteria and input/output formats was often more important than memorizing individual commands. ## Skills and Feedback Loops - Weekly meeting-note preparation revealed recurring editing patterns and implicit business rules. - These rules were encoded into Codex and Claude skills covering: - Note structure - Action-item extraction - PMO-related signals - Situations where the AI should ask questions instead of making assumptions - Skills functioned as stored decision criteria, not merely collections of prompts. - Comparing AI-generated drafts with the author’s final revisions enabled continuous refinement. - Deleting local data for security reasons accidentally removed useful conversation context, temporarily reducing skill quality and demonstrating the importance of preserving relevant operational knowledge. ## Using Outputs as New Inputs - Google Analytics reporting became more frequent and detailed through MCP-based API access and reusable reporting skills. - MCP provided the data connection, while skills preserved the recurring monthly report structure. - The valuable work remained interpreting changes between periods and deciding whether a change was meaningful. - Combining AI-generated metrics with the author’s contextual knowledge helped surface signals requiring further investigation in near real time. The author recommends focusing less on how much code AI can generate and more on how work can be clearly structured for AI execution. As agents become more capable, everyone—not only developers—will increasingly define inputs, outputs, permissions, security controls, repetition, and validation as part of everyday work.

figma

Bring real content into your designs in seconds | Figma Blog (opens in new tab)

Designing with realistic content helps teams stress-test layouts and better predict how interfaces will look in production. This 2019 Figma article highlights plugins that populate designs with text, images, maps, and custom data, reducing the need for manual entry. It concludes that real or organization-specific data can improve accuracy, while private plugins support sensitive internal information. ## Google Sheets Sync - Syncs spreadsheet data directly into Figma layers. - Uses unique column headers such as `Name` or `Address`. - Layers reference columns with names like `#Name` and `#Address`. - Supports formulas and future spreadsheet updates. - Can use image URLs to populate image fills. ## Unsplash - Provides access to more than one million free, high-resolution photographs. - Users can browse categories, select random images, or search the collection. - Images can be inserted directly onto the canvas or applied as image fills to selected elements. ## Data Lab - Populates text using customizable variables such as `{NAME}`, `{EMAIL}`, and `{DATE}`. - Variables can be combined into formatted strings, for example `{NAME} · {EMAIL}`. - Supports names, numbers, dates, phone numbers, emails, and comma-separated lists. ## Content Reel - Includes names, phone numbers, addresses, numbers, emails, URLs, companies, usernames, and countries. - Offers drag-and-drop customization for formatting data, including address fields and comma placement. - Provides access to the Segoe MDL2 icon library. - Its compact mode keeps the plugin available without taking up much workspace. - Planned image-content support would extend it to profile pictures and similar assets. ## Mapsicle - Adds Mapbox maps as image fills inside selected design elements. - Supports custom Mapbox themes and presets such as Light, Dark, Satellite, and Streets. - Allows control over zoom, pitch, and camera rotation. - Existing maps can be refreshed for new dimensions while preserving zoom settings. - Maps placed inside scrolling frames can support horizontal and vertical panning in prototypes. - A Mapbox access token is especially useful for custom themes. Using realistic content makes mockups more credible and exposes layout problems earlier. For sensitive or proprietary data, teams on Figma’s Organization plan can create private plugins connected to internal APIs.