将 Google Sheets 接入 Open Flow
向 AI 助手提供工作簿链接和单元格范围,让它总结数据或写入指定修改。
每月 20,000 次免费应用调用(付费服务另计)
可以做什么
Google Sheets 通过工作表和单元格范围组织数据。连接 Google 账号后,可以读取数值、维护表格,并调整工作表结构。
读取与分析数据范围
读取一个或多个范围,并统计数值列。
写入与维护行数据
追加行、更新单元格范围,或按键值匹配行来维护表格。
整理工作表
查看工作表名称、添加工作表,并设置指定单元格格式。
使用 Google Sheets 的模板


Import Sheet Manufacturers to Shopware
Upsert manufacturers, translations and logo URLs from Google Sheets into Shopware.


Log Location Attendance to Sheets
Log check-in and check-out events from location shortcuts to a Google Sheet.


Research Sales Accounts in Google Sheets
Research companies on the web and update their matching spreadsheet rows.


Schedule Blog Writing and WordPress Publication
Use a Google Sheet to generate blog content by stage and publish scheduled posts to WordPress.


Process Colombian Invoices from Gmail ZIP
Extract Colombian invoice information from ZIP attachments and organize the PDF and invoice row.


Reply to Gmail with Feedback in Sheets
Reply to selected Gmail messages and record recipient feedback in Google Sheets.
更多模板(90)


Sync Sheet Values to a Form Dropdown
Keep a form dropdown aligned with a Google Sheets column.


Scan Integration Sheets and Generate FAQs
Scan four integration sheets and generate a FAQ JSON for each unfinished row.


Generate FAQ JSON for an Integration Row
Generate an integration FAQ JSON file and mark its source sheet row done.


Collect Daily Product Hunt Posts
Collect up to ten Product Hunt posts for a UTC day and maintain a Google Sheets list.


Update and Archive USD Exchange Rates
Refresh a USD exchange rate row and append a historical snapshot in Google Sheets.


Draft LinkedIn Posts from Ghost Articles
Draft LinkedIn promotional copy for recent Ghost posts and record it in Google Sheets.


Reply to Gmail and Record Feedback
Draft replies to selected Gmail messages and record recipient feedback in Google Sheets.


Analyze Qdrant Review Clusters
Cluster stored review vectors and append customer insights to a spreadsheet.


Draft and Approve Printify Product Copy
Generate three product copy options in Sheets and apply an approved option to its Printify shop.


Add AI Summaries to WordPress Posts
Add an AI summary to recent WordPress posts, log each update and notify Slack.


Record Receipt Emails in Google Sheets
Extract the first receipt attachment from matching emails and record its fields in a sheet.


Generate Exam Questions from Google Docs
Index a Google Doc, generate open and multiple-choice questions, and write grounded answers to two sheets.


Register Event Attendees and Invite to Channels
Record a registration, invite the attendee to selected session channels and add them to calendar events.


Archive Gmail Invoices in Drive and Sheets
Save unread email PDF invoices to Drive and append extracted invoice details to a reconciliation sheet.


Author and Publish Scheduled Blog Posts
Generate blog content from scheduled spreadsheet rows and publish due posts to WordPress.


Send Follow-up Campaigns from Google Sheets
Send a configurable email sequence to contacts and stop follow-ups after a reply.


Track Crunchbase Funding Rounds in Google Sheets
Track recent seed and Series A/B funding rounds with company details in Google Sheets.


Extract Image Text to Google Sheets
Extract text from an image with Amazon Rekognition and append the result to Google Sheets.


Sync Google Sheet Contacts to Mautic
Keep Mautic contacts aligned with email, first name and mobile fields in a Google Sheet.


Map Customers to Google Sheets
Map customer fields and upsert them by ID in a Google Sheet.


Classify Website Domains in Google Sheets
Read website domains from a sheet, classify each site and update the matching row.


Save Slack Ideas to Google Sheets
Save ideas from a Slack slash command to Google Sheets and reply with a details link.


Random User Name and Country to CSV and Sheets
Fetch a random user, create a CSV and append the same fields to Google Sheets.


Random User to CSV and Google Sheets
Fetch a random user, create a CSV and append the same fields to Google Sheets.


Classify Customer Feedback to Google Sheets
Classify customer feedback sentiment and save the feedback with the result in Google Sheets.


Import 2023 DACH COVID Testing Data
Import 2023 COVID testing records for Germany, Austria and Switzerland into Google Sheets.


Import an XML Breakfast Menu to Google Sheets
Download a breakfast menu XML file and create a Google spreadsheet containing its items.


Record LINE Receipt Images in Google Sheets
Archive LINE receipt images and record extracted Thai transfer details in Google Sheets.


Save Form Submissions to Airtable and Google Sheets
Store form submissions in Airtable and Google Sheets and send a message after each write.


Create Latest Sheet Event in Google Calendar
Create a Google Calendar all-day event from the latest newly added sheet row.


Verify Sheet Emails with Icypeas
Submit Google Sheet email addresses to Icypeas bulk verification.


Scan Sheet Domains with Icypeas
Submit Google Sheet companies to Icypeas bulk domain search.


Search Sheet Contacts with Icypeas
Submit Google Sheet contacts to Icypeas bulk email search.


Append an ID and Name to Google Sheets
Append an ID and name to a Google Sheet and read the table.


Append and Adjust Berlin Rent in Google Sheets
Append an example property and increase rent for matching Berlin rows.


Download a Google Sheet as an HTML Table
Download a Google Sheets range as an HTML table through a webhook.


Send Scheduled Congratulations from Sheets
Send personalized SMS greetings for events listed in Google Sheets.


Monitor Competitor Pricing Changes
Compare competitor pricing pages with saved summaries and notify a Slack channel of changes.


Send Telegram Messages from a Sheet in Batches
Send a message to Telegram chat IDs listed in a Google Sheet, with a pause after each batch.


Log Unread Gmail Classifications to Sheets
Classify new unread Gmail messages and log the results in a spreadsheet.


Save Sheet Website Screenshots to Drive
Capture websites listed in newly added spreadsheet rows and save PNG files to Google Drive.


Find LinkedIn Profiles for Sheet Rows
Search for LinkedIn profiles using person descriptions in a Google Sheet and update the corresponding rows.


Copy Sheet Data to Two Destinations
Copy a Google Sheets data range to two destination spreadsheets every two minutes.


Summarize New Google Docs to Sheets
Summarize new Google Docs in a Drive folder and append each summary with its last editor to Sheets.


Validate Sheet Email Deliverability
Validate changed email addresses and write deliverability results to their Google Sheets rows.


Save Taiwan Sheep Prices to Google Sheets
Fetch Taiwan sheep market quotations for a date range and append them to Google Sheets.


Enrich Sheet Companies with ProspectLens
Enrich unprocessed company domains in Google Sheets with ProspectLens data.


Sync Trustpilot Reviews to Sheets
Collect public Trustpilot reviews into general and HelpfulCrowd-format sheets.


Sync a Squarespace Collection to Sheets
Keep a Google Sheets inventory of a public Squarespace blog collection up to date.


Summarize New Google Docs to Sheets
Summarize new Google Docs in a Drive folder and append each summary with its last editor to Sheets.


Track Amazon Prices from Sheets
Track Amazon product prices from a sheet, record price history and email threshold alerts.


Classify WordPress Inquiries and Draft Replies
Classify incoming WordPress contact inquiries, prepare Gmail drafts for review and log the inquiries in Google Sheets.


Send Sheet Investment Updates to Discord
Watch investment security codes and send the complete sheet table to Discord when rows are added or codes change.


Log and Route Twenty CRM Events
Log signed Twenty CRM record events and notify email for deletions or Slack for other changes.


Route Course Feedback to Google Sheets
Route course feedback into positive or negative Google Sheets based on the usefulness answer.


Archive Whitelisted Email Attachments to Drive
Save attachments from whitelisted senders into company and month folders in Google Drive.


Extract Inbound Orders to Google Sheets
Extract purchase order lines from matching Gmail messages and append them to Google Sheets.


Monitor Website Status in Google Sheets
Check website status, record observations and alert a team when a site is down or recovers.


Import Sheet Contacts to Salesforce
Find or create Salesforce accounts and upsert sheet contacts by email.


Import Squarespace Signups to Mailchimp
Add newsletter signups from a Google Sheet to a Mailchimp audience with their signup times.


Post Queued Google Sheets Rows to X
Post queued sheet rows to X every six hours and remove the posted rows.


Save Google Maps Business Leads to Sheets
Search Google Maps for businesses and append their details to Google Sheets.


Send Scheduled Customer Emails from Sheets
Send today’s queued customer emails and mark each successful send in Google Sheets.


Monitor Sheet URLs to Telegram
Check URLs in Google Sheets every minute and send failed checks to Telegram.


Send Instagram Sheet Metrics to Mattermost
Read daily Instagram metrics from a sheet and send a message for each row.


Monitor Sheet Servers and Email Alerts
Check servers listed in Google Sheets every minute, log their status and email an alert when a check fails.


Session Feedback to Mattermost
Read session rows and post each feedback form to its Mattermost channel.


New Google Sheet Rows to Mattermost
Read a sheet every minute and notify a Mattermost channel about new rows, newest first.


Extract Book Listings to Google Sheets
Read a book catalogue page, extract listings with AI and append them to a Google Sheet.


Telegram Journal Replies to Google Sheets
Save a specified user’s reply to a bot’s dated journal prompt as an entry in Google Sheets.


Gmail Message Snippets to Google Sheets
Append the sender, subject and Gmail snippet of each new message to a spreadsheet.


Classify Software Keywords in Google Sheets
Classify every keyword as containing a known IT software or service name, wait five seconds per six-row batch and update only matching Service? cells by Number.


Google Sheets Community Lead Rating
Rate newly appended community applications using the original responsibility and email-domain criteria, then update only the matching Timestamp row’s Rating.


Sheet Contacts through Dropcontact to Lemlist
Read a sheet contact batch, enrich it with French company information, wait 45 seconds and create every returned contact as a Lemlist campaign lead.


EU Company Register to Google Sheets
Look up every company row across seven national registers with the original Apify Actor, wait for complete results, then update or append the selected registration fields in Google Sheets.


Google Sheet Table JSON API
Read a configured Google Sheet range and return every data row as a JSON object keyed by the first row.


Airtable Contacts to Google Sheets
Sync recently updated Airtable records into an existing Google Sheet, matching exact Email keys and using RAW values and the A1:E1000 lookup window.


LeadPilot Cold Email Drafts
Write personalized cold-email and follow-up drafts for every supplied lead, then save the complete batch in Google Sheets for review.


Typeform Problem Report Routing
Log every completed Typeform problem report in Google Sheets, then send severe reports to Slack and other reports by email.


Hebrew WhatsApp Invoice Reminders
Send Hebrew WAHA reminders for open invoices exactly 7, 14 or 30 calendar days overdue, and record each accepted reminder in Google Sheets.


Four Platform Content Repurposer
Analyze supplied content, write separate X, LinkedIn, Instagram and Facebook drafts, and log one complete set in Google Sheets.


API Operations Schema Export
Group a service’s API operation rows from Google Sheets into a custom JSON catalog and save the export in Google Drive.


Google Sheet Record Lookup
List a Google Sheet’s columns, read one column with row numbers, or retrieve a record by its physical row number.


Reddit Trend Log
Rank a subreddit’s hot posts, ask AI for trends and content ideas, and record one daily analysis row in Google Sheets.


Customer Feedback Sentiment
Classify submitted customer feedback with AI and save the feedback, contact information, and sentiment in Google Sheets.


Client Onboarding
Welcome a new client by Gmail, record their project in Google Sheets, and return the client ID to your form or CRM.


Phone Call Log
Record caller details, duration, supplied summary, and the first 500 transcript characters in Google Sheets from a webhook.


Event Feedback Report
Summarize Google Sheets event feedback into an AI report covering sentiment and improvement ideas, and email it with Gmail.


Invoice Payment Reminders
Email Italian payment reminders for unpaid invoices that are overdue or due within three days, every weekday morning.


Website Lead Capture
Save website leads to Google Sheets, notify your team on Telegram, and acknowledge the enquiry by Gmail.
所有工具
Add Sheet
通过 spreadsheets.batchUpdate 添加新工作表,并返回稳定的批量回复。
googlesheets.add_sheetAggregate Column Data
聚合目标列中的数值,可选择按另一列过滤,并带有稳定计数器。
googlesheets.aggregate_column_dataAppend Dimension
通过 spreadsheets.batchUpdate 追加行或列,并返回稳定的批量回复。
googlesheets.append_dimensionAuto Resize Dimensions
通过 spreadsheets.batchUpdate 自动调整行或列的大小,并返回稳定的批量回复。
googlesheets.auto_resize_dimensionsBatch Clear Values By Data Filter
通过 values.batchClearByDataFilter 清除电子表格值,并返回已清除的范围。
googlesheets.batch_clear_values_by_data_filterBatch Get
通过 values:batchGet 读取多个电子表格范围,并返回稳定的 valueRanges 输出。
googlesheets.batch_getBatch Update Values By Data Filter
通过 values.batchUpdateByDataFilter 写入电子表格值,并返回稳定的聚合计数器。
googlesheets.batch_update_values_by_data_filterClear Basic Filter
通过 spreadsheets.batchUpdate 清除基本筛选器,并返回稳定的批量回复。
googlesheets.clear_basic_filterClear Values
通过 values.clear 清除单个电子表格值范围,并返回已清除的 A1 范围。
googlesheets.clear_valuesCreate Chart
通过 spreadsheets.batchUpdate 创建图表,并返回稳定的批量回复。
googlesheets.create_chartCreate Google Sheet1
创建 Google Sheets 电子表格,并返回新文件的稳定电子表格元数据。
googlesheets.create_google_sheet1Create Spreadsheet Column
通过 spreadsheets.batchUpdate 在工作表中插入空列,并返回稳定的顶层字段。
googlesheets.create_spreadsheet_columnCreate Spreadsheet Row
通过 spreadsheets.batchUpdate 在工作表中插入空行,并返回稳定的顶层字段。
googlesheets.create_spreadsheet_rowDelete Dimension
通过 spreadsheets.batchUpdate 删除行或列,并返回稳定的批量回复。
googlesheets.delete_dimensionDelete Sheet
通过 spreadsheets.batchUpdate 删除工作表,并返回稳定的批量回复。
googlesheets.delete_sheetFind Replace
通过 spreadsheets.batchUpdate 运行查找和替换,并返回稳定的批量回复。
googlesheets.find_replaceFormat Cell
通过 spreadsheets.batchUpdate 格式化单元格,并返回稳定的批量回复。
googlesheets.format_cellGet Conditional Format Rules
读取电子表格条件格式规则,并将其投影为稳定的按工作表结构。
googlesheets.get_conditional_format_rulesGet Data Validation Rules
从所需的最小工作表范围读取电子表格数据验证规则,并返回扁平化的规则条目。
googlesheets.get_data_validation_rulesGet Sheet Names
列出电子表格中可见或所有工作表名称,并包含稳定的名称到 sheetId 映射。
googlesheets.get_sheet_namesGet Spreadsheet By Data Filter
通过 spreadsheets.getByDataFilter 读取电子表格元数据,并返回规范化电子表格载荷。
googlesheets.get_spreadsheet_by_data_filterGet Spreadsheet Info
通过 spreadsheets.get 读取电子表格元数据,并带有可选范围和网格数据标志。
googlesheets.get_spreadsheet_infoInsert Dimension
通过 spreadsheets.batchUpdate 插入行或列,并返回稳定的批量回复。
googlesheets.insert_dimensionLookup Spreadsheet Row
查找第一个单元格与查询完全匹配的行,并返回稳定的 found/rowData 载荷。
googlesheets.lookup_spreadsheet_rowMutate Conditional Format Rules
通过 spreadsheets.batchUpdate 修改条件格式规则,并返回稳定的批量回复。
googlesheets.mutate_conditional_format_rulesSearch Developer Metadata
通过 developerMetadata:search 搜索电子表格开发者元数据,仅返回匹配的条目。
googlesheets.search_developer_metadataSearch Spreadsheets
使用仅电子表格的过滤器搜索 Drive 中的 Google Sheets 文件,并输出规范化摘要。
googlesheets.search_spreadsheetsSet Basic Filter
通过 spreadsheets.batchUpdate 设置基本过滤器,并返回稳定的批量回复。
googlesheets.set_basic_filterSet Data Validation Rule
通过 spreadsheets.batchUpdate 设置或清除数据验证,并返回稳定的批量回复。
googlesheets.set_data_validation_ruleSpreadsheets Sheets Copy To
通过 sheets.copyTo 将工作表复制到另一个电子表格,并返回稳定的 copiedSheet 载荷。
googlesheets.spreadsheets_sheets_copy_toSpreadsheets Values Append
通过 values.append 追加值,并将嵌套的更新载荷展平为稳定的顶层字段。
googlesheets.spreadsheets_values_appendSpreadsheets Values Batch Clear
通过 values.batchClear 清除多个电子表格值范围,仅返回已清除的范围。
googlesheets.spreadsheets_values_batch_clearSpreadsheets Values Batch Get By Data Filter
通过 values:batchGetByDataFilter 读取电子表格值,并返回匹配的值范围及其过滤器。
googlesheets.spreadsheets_values_batch_get_by_data_filterUpdate Dimension Properties
通过 spreadsheets.batchUpdate 更新行或列属性,并返回稳定的批量回复。
googlesheets.update_dimension_propertiesUpdate Sheet Properties
通过 spreadsheets.batchUpdate 更新工作表的属性,并返回稳定的批量回复。
googlesheets.update_sheet_propertiesUpdate Spreadsheet Properties
通过 spreadsheets.batchUpdate 更新电子表格级属性,并返回稳定的批量回复。
googlesheets.update_spreadsheet_propertiesUpdate Values Batch
通过 values.batchUpdate 写入多个电子表格值范围,并返回稳定的聚合计数器。
googlesheets.update_values_batchUpsert Rows
按键更新或插入行,同时保留未覆盖的列,在需要时添加缺失的标题,并返回稳定的计数器。
googlesheets.upsert_rowsValues Get
读取单个电子表格值范围,并返回稳定的 ValueRange,不带包装信封。
googlesheets.values_getValues Update
通过 values.update 写入单个电子表格值范围,并返回稳定的更新计数器。
googlesheets.values_update没有符合搜索条件的工具。
将 Google Sheets 接入 Open Flow
每月 20,000 次免费应用调用(付费服务另计)