skills.rest
TK0918
TK0918COMMUNITY
Explore all skills by this author →
GitHub

lark-sheets

Automate spreadsheet creation, reading, updating, and customization with OAuth authentication.

Updated Jun 7, 2025
Search Tags:#automation#data analysis#spreadsheet#export#image insertion#cell styling#filter management
One-click install
npx skills add https://github.com/TK0918/BestAds --skill lark-sheets-tk0918
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: lark-sheets
Source: https://github.com/TK0918/BestAds/tree/main/.agents/skills/lark-sheets
Command: npx skills add https://github.com/TK0918/BestAds --skill lark-sheets-tk0918

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill simplifies the process of creating, reading, writing, and managing spreadsheets by automating complex and repetitive operations.

Core Features & Use Cases

  • Create and Share Spreadsheets: Instantly generate new spreadsheets with optional headers and data, and organize them within folders.
  • Read and Write Data: Bulk fetch or update cell values, supporting formula and style manipulations to customize spreadsheet appearance and content.
  • Configure Filters and Views: Create, update, and delete filters, filter views, and filter conditions for data analysis.
  • Add, Remove, and Modify Dimensions: Insert or delete rows and columns, move or resize them, and adjust visibility or styles efficiently.
  • Design and Export: Set cell styles, merge or unmerge cells, add floating images, configure dropdowns, and export spreadsheets in various formats.
  • Read and Manipulate Images: Upload images, insert into cells, and adjust floating images' position or size for rich visual presentation.
  • Advanced Operations: Manage floating images, create filter views, and handle complex cell data types like formulas, mentions, and dropdowns.

Quick Start

Create a new spreadsheet titled "Monthly Report" with headers for sales data and then read back specific ranges to verify contents.

Frequently Asked Questions about lark-sheets

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate spreadsheet creation and data export for reporting?▼

Automate spreadsheet creation and data export by generating sheets with headers, bulk writing cell values, and exporting spreadsheets in various formats for reporting.

Can I insert images and configure cell styling within a spreadsheet using automation?▼

Insert images and configure cell styling by uploading images into cells, adjusting floating image positions, setting cell styles, and merging cells for visual enhancement.

How do I manage filters and filter views for spreadsheet data analysis?▼

Manage spreadsheet data analysis filters by creating, updating, and deleting filter views and filter conditions to isolate specific data ranges.

Does spreadsheet automation support complex cell data types like formulas and dropdowns?▼

Spreadsheet automation supports complex cell data types including formulas, mentions, and dropdown configurations to customize content and appearance.

What do I need to set up before automating spreadsheet operations?▼

You need OAuth authentication and permission management configured before automating spreadsheet operations, ensuring correct resource identification for seamless access.

How do I insert or delete rows and columns to adjust dimensions in a spreadsheet?▼

Adjust spreadsheet dimensions by inserting or deleting rows and columns, moving or resizing them, and modifying visibility or styles efficiently.

Related Skills

Explore More Product & Management Skills→
fuzheadofuzheado
15

wikimedia-auth-oauth

Authenticate Wikimedia API clients using OAuth and bot passwords.

Community
Advanced
EvezArtEvezArt
3

excel-generator

Automate creation of formatted Excel spreadsheets for data analysis and reporting.

Community
Advanced
heximaoheximao

lark-sheets

Manage Lark spreadsheets with sheet, cell, style, image, and filter operations.

Community
Advanced
dreamtidesdreamtides

univer

Create and manipulate dynamic spreadsheet applications with the Univer TypeScript library.

Official
Advanced