# 将 Google Sheets 接入 Open Flow

Source: https://openflow.run/zh-cn/integrations/googlesheets/

[全部集成](https://openflow.run/zh-cn/integrations/)

向 AI 助手提供工作簿链接和单元格范围，让它总结数据或写入指定修改。

*   [40 个工具](https://openflow.run/zh-cn/integrations/googlesheets/#integration-actions)
*   OAuth 2.0
*   效率工具
*   数据与分析
*   文档与内容

[连接 Google Sheets](https://console.openflow.run/connections/googlesheets)

每月 20,000 次免费应用调用（付费服务另计）

## 可以做什么

Google Sheets 通过工作表和单元格范围组织数据。连接 Google 账号后，可以读取数值、维护表格，并调整工作表结构。

### 读取与分析数据范围

读取一个或多个范围，并统计数值列。

### 写入与维护行数据

追加行、更新单元格范围，或按键值匹配行来维护表格。

### 整理工作表

查看工作表名称、添加工作表，并设置指定单元格格式。

## 使用 Google Sheets 的模板

![Import Sheet Manufacturers to Shopware 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/import-sheet-manufacturers-to-shopware/light-cover.webp)

电商

### [Import Sheet Manufacturers to Shopware](https://openflow.run/zh-cn/templates/import-sheet-manufacturers-to-shopware/)

Upsert manufacturers, translations and logo URLs from Google Sheets into Shopware.

![Log Location Attendance to Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/log-location-attendance-to-sheets/light-cover.webp)

效率

### [Log Location Attendance to Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/research-sales-accounts-in-sheets/light-cover.webp)

销售

### [Research Sales Accounts in Google Sheets](https://openflow.run/zh-cn/templates/research-sales-accounts-in-sheets/)

Research companies on the web and update their matching spreadsheet rows.

![Schedule Blog Writing and WordPress Publication 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/schedule-blog-writing-and-wordpress-publication/light-cover.webp)

营销

### [Schedule Blog Writing and WordPress Publication](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/process-colombian-invoices-from-gmail-zip/light-cover.webp)

财务+1

### [Process Colombian Invoices from Gmail ZIP](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/reply-to-gmail-with-feedback-sheet/light-cover.webp)

效率

### [Reply to Gmail with Feedback in Sheets](https://openflow.run/zh-cn/templates/reply-to-gmail-with-feedback-sheet/)

Reply to selected Gmail messages and record recipient feedback in Google Sheets.

更多模板（90）

![Sync Sheet Values to a Form Dropdown 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/sync-sheet-values-to-form-dropdown/light-cover.webp)

效率

### [Sync Sheet Values to a Form Dropdown](https://openflow.run/zh-cn/templates/sync-sheet-values-to-form-dropdown/)

Keep a form dropdown aligned with a Google Sheets column.

![Scan Integration Sheets and Generate FAQs 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/scan-integration-sheets-and-generate-faq/light-cover.webp)

内容

### [Scan Integration Sheets and Generate FAQs](https://openflow.run/zh-cn/templates/scan-integration-sheets-and-generate-faq/)

Scan four integration sheets and generate a FAQ JSON for each unfinished row.

![Generate FAQ JSON for an Integration Row 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/generate-faq-json-for-integration-rows/light-cover.webp)

内容

### [Generate FAQ JSON for an Integration Row](https://openflow.run/zh-cn/templates/generate-faq-json-for-integration-rows/)

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

![Collect Daily Product Hunt Posts 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/collect-daily-product-hunt-posts/light-cover.webp)

研究

### [Collect Daily Product Hunt Posts](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/update-and-archive-usd-exchange-rates/light-cover.webp)

财务

### [Update and Archive USD Exchange Rates](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/draft-linkedin-posts-from-ghost-articles/light-cover.webp)

营销

### [Draft LinkedIn Posts from Ghost Articles](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/draft-gmail-replies-with-sheet-feedback/light-cover.webp)

效率

### [Reply to Gmail and Record Feedback](https://openflow.run/zh-cn/templates/draft-gmail-replies-with-sheet-feedback/)

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

![Analyze Qdrant Review Clusters 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/analyze-qdrant-review-clusters/light-cover.webp)

AI

### [Analyze Qdrant Review Clusters](https://openflow.run/zh-cn/templates/analyze-qdrant-review-clusters/)

Cluster stored review vectors and append customer insights to a spreadsheet.

![Draft and Approve Printify Product Copy 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/draft-and-approve-printify-product-copy/light-cover.webp)

Ecommerce

### [Draft and Approve Printify Product Copy](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/add-ai-summaries-to-wordpress-posts/light-cover.webp)

内容

### [Add AI Summaries to WordPress Posts](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/record-receipt-emails-in-google-sheets/light-cover.webp)

财务

### [Record Receipt Emails in Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/generate-exam-questions-from-google-docs/light-cover.webp)

Education

### [Generate Exam Questions from Google Docs](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/register-event-attendees-and-invite-to-channels/light-cover.webp)

Events+1

### [Register Event Attendees and Invite to Channels](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/archive-gmail-invoices-in-drive-and-sheets/light-cover.webp)

财务

### [Archive Gmail Invoices in Drive and Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/author-and-publish-scheduled-blog-posts/light-cover.webp)

营销

### [Author and Publish Scheduled Blog Posts](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/send-follow-up-campaigns-from-google-sheets/light-cover.webp)

销售

### [Send Follow-up Campaigns from Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/track-crunchbase-funding-rounds-in-sheets/light-cover.webp)

销售

### [Track Crunchbase Funding Rounds in Google Sheets](https://openflow.run/zh-cn/templates/track-crunchbase-funding-rounds-in-sheets/)

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

![Extract Image Text to Google Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/extract-image-text-to-google-sheets/light-cover.webp)

效率

### [Extract Image Text to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/sync-sheet-contacts-to-mautic/light-cover.webp)

营销

### [Sync Google Sheet Contacts to Mautic](https://openflow.run/zh-cn/templates/sync-sheet-contacts-to-mautic/)

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

![Map Customers to Google Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/map-customers-to-google-sheet/light-cover.webp)

效率

### [Map Customers to Google Sheets](https://openflow.run/zh-cn/templates/map-customers-to-google-sheet/)

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

![Classify Website Domains in Google Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/classify-website-domains-in-google-sheets/light-cover.webp)

研究

### [Classify Website Domains in Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/slack-ideas-to-google-sheets/light-cover.webp)

效率

### [Save Slack Ideas to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/random-user-name-and-country-to-csv-and-sheets/light-cover.webp)

Data

### [Random User Name and Country to CSV and Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/random-user-to-csv-and-google-sheets/light-cover.webp)

Data

### [Random User to CSV and Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/classify-customer-feedback-to-google-sheets/light-cover.webp)

客户支持

### [Classify Customer Feedback to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/import-2023-dach-covid-testing-data/light-cover.webp)

Data

### [Import 2023 DACH COVID Testing Data](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/import-an-xml-breakfast-menu-to-google-sheets/light-cover.webp)

Data

### [Import an XML Breakfast Menu to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/record-line-receipts-in-google-sheets/light-cover.webp)

效率

### [Record LINE Receipt Images in Google Sheets](https://openflow.run/zh-cn/templates/record-line-receipts-in-google-sheets/)

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

![Save Form Submissions to Airtable and Google Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/save-form-submissions-to-airtable-and-sheets/light-cover.webp)

效率

### [Save Form Submissions to Airtable and Google Sheets](https://openflow.run/zh-cn/templates/save-form-submissions-to-airtable-and-sheets/)

Store form submissions in Airtable and Google Sheets and send a message after each write.

![Create Latest Sheet Event in Google Calendar 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/create-latest-sheet-event-in-google-calendar/light-cover.webp)

效率

### [Create Latest Sheet Event in Google Calendar](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/verify-sheet-emails-with-icypeas/light-cover.webp)

销售

### [Verify Sheet Emails with Icypeas](https://openflow.run/zh-cn/templates/verify-sheet-emails-with-icypeas/)

Submit Google Sheet email addresses to Icypeas bulk verification.

![Scan Sheet Domains with Icypeas 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/scan-sheet-domains-with-icypeas/light-cover.webp)

销售

### [Scan Sheet Domains with Icypeas](https://openflow.run/zh-cn/templates/scan-sheet-domains-with-icypeas/)

Submit Google Sheet companies to Icypeas bulk domain search.

![Search Sheet Contacts with Icypeas 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/search-sheet-contacts-with-icypeas/light-cover.webp)

销售

### [Search Sheet Contacts with Icypeas](https://openflow.run/zh-cn/templates/search-sheet-contacts-with-icypeas/)

Submit Google Sheet contacts to Icypeas bulk email search.

![Append an ID and Name to Google Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/append-id-and-name-to-google-sheets/light-cover.webp)

效率

### [Append an ID and Name to Google Sheets](https://openflow.run/zh-cn/templates/append-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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/append-and-adjust-berlin-rent-in-sheets/light-cover.webp)

效率

### [Append and Adjust Berlin Rent in Google Sheets](https://openflow.run/zh-cn/templates/append-and-adjust-berlin-rent-in-sheets/)

Append an example property and increase rent for matching Berlin rows.

![Download a Google Sheet as an HTML Table 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/download-sheet-as-html-table/light-cover.webp)

效率

### [Download a Google Sheet as an HTML Table](https://openflow.run/zh-cn/templates/download-sheet-as-html-table/)

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

![Send Scheduled Congratulations from Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/send-scheduled-congratulations-from-sheets/light-cover.webp)

效率

### [Send Scheduled Congratulations from Sheets](https://openflow.run/zh-cn/templates/send-scheduled-congratulations-from-sheets/)

Send personalized SMS greetings for events listed in Google Sheets.

![Monitor Competitor Pricing Changes 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/monitor-competitor-pricing-changes/light-cover.webp)

研究

### [Monitor Competitor Pricing Changes](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/send-telegram-messages-from-sheet-in-batches/light-cover.webp)

Communications

### [Send Telegram Messages from a Sheet in Batches](https://openflow.run/zh-cn/templates/send-telegram-messages-from-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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/log-unread-gmail-classifications-to-sheets/light-cover.webp)

效率

### [Log Unread Gmail Classifications to Sheets](https://openflow.run/zh-cn/templates/log-unread-gmail-classifications-to-sheets/)

Classify new unread Gmail messages and log the results in a spreadsheet.

![Save Sheet Website Screenshots to Drive 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/save-sheet-website-screenshots-to-drive/light-cover.webp)

效率

### [Save Sheet Website Screenshots to Drive](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/find-linkedin-profiles-for-sheet-rows/light-cover.webp)

销售

### [Find LinkedIn Profiles for Sheet Rows](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/copy-sheet-data-to-two-destinations/light-cover.webp)

效率

### [Copy Sheet Data to Two Destinations](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/summarize-new-drive-documents-to-sheets/light-cover.webp)

效率

### [Summarize New Google Docs to Sheets](https://openflow.run/zh-cn/templates/summarize-new-drive-documents-to-sheets/)

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

![Validate Sheet Email Deliverability 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/validate-sheet-email-deliverability/light-cover.webp)

销售

### [Validate Sheet Email Deliverability](https://openflow.run/zh-cn/templates/validate-sheet-email-deliverability/)

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

![Save Taiwan Sheep Prices to Google Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/save-taiwan-sheep-prices-to-sheets/light-cover.webp)

Data

### [Save Taiwan Sheep Prices to Google Sheets](https://openflow.run/zh-cn/templates/save-taiwan-sheep-prices-to-sheets/)

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

![Enrich Sheet Companies with ProspectLens 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/enrich-sheet-companies-with-prospectlens/light-cover.webp)

销售

### [Enrich Sheet Companies with ProspectLens](https://openflow.run/zh-cn/templates/enrich-sheet-companies-with-prospectlens/)

Enrich unprocessed company domains in Google Sheets with ProspectLens data.

![Sync Trustpilot Reviews to Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/sync-trustpilot-reviews-to-sheets/light-cover.webp)

营销

### [Sync Trustpilot Reviews to Sheets](https://openflow.run/zh-cn/templates/sync-trustpilot-reviews-to-sheets/)

Collect public Trustpilot reviews into general and HelpfulCrowd-format sheets.

![Sync a Squarespace Collection to Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/sync-squarespace-collection-to-sheets/light-cover.webp)

营销

### [Sync a Squarespace Collection to Sheets](https://openflow.run/zh-cn/templates/sync-squarespace-collection-to-sheets/)

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

![Summarize New Google Docs to Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/summarize-new-google-docs-to-sheets/light-cover.webp)

效率

### [Summarize New Google Docs to Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/track-amazon-prices-from-sheets/light-cover.webp)

运营

### [Track Amazon Prices from Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/classify-wordpress-inquiries-and-draft-replies/light-cover.webp)

客户支持

### [Classify WordPress Inquiries and Draft Replies](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/send-sheet-investment-updates-to-discord/light-cover.webp)

效率

### [Send Sheet Investment Updates to Discord](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/log-and-route-twenty-crm-events/light-cover.webp)

销售

### [Log and Route Twenty CRM Events](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/route-course-feedback-to-google-sheets/light-cover.webp)

Education

### [Route Course Feedback to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/archive-whitelisted-email-attachments-to-drive/light-cover.webp)

效率

### [Archive Whitelisted Email Attachments to Drive](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/extract-inbound-orders-to-google-sheets/light-cover.webp)

运营

### [Extract Inbound Orders to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/monitor-website-status-in-google-sheets/light-cover.webp)

运营

### [Monitor Website Status in Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/import-sheet-contacts-to-salesforce/light-cover.webp)

销售

### [Import Sheet Contacts to Salesforce](https://openflow.run/zh-cn/templates/import-sheet-contacts-to-salesforce/)

Find or create Salesforce accounts and upsert sheet contacts by email.

![Import Squarespace Signups to Mailchimp 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/import-squarespace-signups-to-mailchimp/light-cover.webp)

营销

### [Import Squarespace Signups to Mailchimp](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/post-queued-sheet-rows-to-x/light-cover.webp)

营销

### [Post Queued Google Sheets Rows to X](https://openflow.run/zh-cn/templates/post-queued-sheet-rows-to-x/)

Post queued sheet rows to X every six hours and remove the posted rows.

![Save Google Maps Business Leads to Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/google-maps-leads-to-sheets/light-cover.webp)

销售

### [Save Google Maps Business Leads to Sheets](https://openflow.run/zh-cn/templates/google-maps-leads-to-sheets/)

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

![Send Scheduled Customer Emails from Sheets 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/send-scheduled-customer-emails-from-sheets/light-cover.webp)

销售

### [Send Scheduled Customer Emails from Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/monitor-sheet-urls-to-telegram/light-cover.webp)

运营

### [Monitor Sheet URLs to Telegram](https://openflow.run/zh-cn/templates/monitor-sheet-urls-to-telegram/)

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

![Send Instagram Sheet Metrics to Mattermost 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/send-instagram-sheet-metrics-to-mattermost/light-cover.webp)

效率

### [Send Instagram Sheet Metrics to Mattermost](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/monitor-sheet-servers-and-email-alerts/light-cover.webp)

运营

### [Monitor Sheet Servers and Email Alerts](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/session-feedback-to-mattermost/light-cover.webp)

效率

### [Session Feedback to Mattermost](https://openflow.run/zh-cn/templates/session-feedback-to-mattermost/)

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

![New Google Sheet Rows to Mattermost 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/new-sheet-rows-to-mattermost/light-cover.webp)

效率

### [New Google Sheet Rows to Mattermost](https://openflow.run/zh-cn/templates/new-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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/extract-book-listings-to-google-sheets/light-cover.webp)

研究

### [Extract Book Listings to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/telegram-journal-replies-to-google-sheets/light-cover.webp)

效率

### [Telegram Journal Replies to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/gmail-message-snippets-to-google-sheets/light-cover.webp)

效率

### [Gmail Message Snippets to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/classify-software-keywords-in-google-sheets/light-cover.webp)

营销

### [Classify Software Keywords in Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/google-sheets-community-lead-rating/light-cover.webp)

销售

### [Google Sheets Community Lead Rating](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/sheet-contacts-dropcontact-lemlist/light-cover.webp)

销售

### [Sheet Contacts through Dropcontact to Lemlist](https://openflow.run/zh-cn/templates/sheet-contacts-dropcontact-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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/eu-company-register-to-google-sheets/light-cover.webp)

Data Enrichment

### [EU Company Register to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/google-sheet-table-json-api/light-cover.webp)

开发者工具

### [Google Sheet Table JSON API](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/airtable-contacts-to-google-sheets/light-cover.webp)

Data Sync

### [Airtable Contacts to Google Sheets](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/leadpilot-cold-email-drafts/light-cover.webp)

销售

### [LeadPilot Cold Email Drafts](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/typeform-problem-report-routing/light-cover.webp)

客户支持

### [Typeform Problem Report Routing](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/hebrew-whatsapp-invoice-reminders/light-cover.webp)

财务

### [Hebrew WhatsApp Invoice Reminders](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/four-platform-content-repurposer/light-cover.webp)

营销

### [Four Platform Content Repurposer](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/api-operations-schema-export/light-cover.webp)

开发者工具

### [API Operations Schema Export](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/google-sheet-record-lookup/light-cover.webp)

效率

### [Google Sheet Record Lookup](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/reddit-trend-log/light-cover.webp)

营销

### [Reddit Trend Log](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/customer-feedback-sentiment/light-cover.webp)

支持

### [Customer Feedback Sentiment](https://openflow.run/zh-cn/templates/customer-feedback-sentiment/)

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

![Client Onboarding 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/client-onboarding/light-cover.webp)

销售

### [Client Onboarding](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/phone-call-log/light-cover.webp)

支持

### [Phone Call Log](https://openflow.run/zh-cn/templates/phone-call-log/)

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

![Event Feedback Report 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/event-feedback-report/light-cover.webp)

运营

### [Event Feedback Report](https://openflow.run/zh-cn/templates/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 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/invoice-payment-reminders/light-cover.webp)

运营

### [Invoice Payment Reminders](https://openflow.run/zh-cn/templates/invoice-payment-reminders/)

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

![Website Lead Capture 在 Open Flow 中的工作流截图](https://openflow.run/template-previews/website-lead-capture/light-cover.webp)

销售

### [Website Lead Capture](https://openflow.run/zh-cn/templates/website-lead-capture/)

Save website leads to Google Sheets, notify your team on Telegram, and acknowledge the enquiry by Gmail.

## 所有工具

40 个工具

### Add Sheet

通过 spreadsheets.batchUpdate 添加新工作表，并返回稳定的批量回复。

`googlesheets.add_sheet`

### Aggregate Column Data

聚合目标列中的数值，可选择按另一列过滤，并带有稳定计数器。

`googlesheets.aggregate_column_data`

### Append Dimension

通过 spreadsheets.batchUpdate 追加行或列，并返回稳定的批量回复。

`googlesheets.append_dimension`

### Auto Resize Dimensions

通过 spreadsheets.batchUpdate 自动调整行或列的大小，并返回稳定的批量回复。

`googlesheets.auto_resize_dimensions`

### Batch Clear Values By Data Filter

通过 values.batchClearByDataFilter 清除电子表格值，并返回已清除的范围。

`googlesheets.batch_clear_values_by_data_filter`

### Batch Get

通过 values:batchGet 读取多个电子表格范围，并返回稳定的 valueRanges 输出。

`googlesheets.batch_get`

### Batch Update Values By Data Filter

通过 values.batchUpdateByDataFilter 写入电子表格值，并返回稳定的聚合计数器。

`googlesheets.batch_update_values_by_data_filter`

### Clear Basic Filter

通过 spreadsheets.batchUpdate 清除基本筛选器，并返回稳定的批量回复。

`googlesheets.clear_basic_filter`

### Clear Values

通过 values.clear 清除单个电子表格值范围，并返回已清除的 A1 范围。

`googlesheets.clear_values`

### Create Chart

通过 spreadsheets.batchUpdate 创建图表，并返回稳定的批量回复。

`googlesheets.create_chart`

### Create Google Sheet1

创建 Google Sheets 电子表格，并返回新文件的稳定电子表格元数据。

`googlesheets.create_google_sheet1`

### Create Spreadsheet Column

通过 spreadsheets.batchUpdate 在工作表中插入空列，并返回稳定的顶层字段。

`googlesheets.create_spreadsheet_column`

### Create Spreadsheet Row

通过 spreadsheets.batchUpdate 在工作表中插入空行，并返回稳定的顶层字段。

`googlesheets.create_spreadsheet_row`

### Delete Dimension

通过 spreadsheets.batchUpdate 删除行或列，并返回稳定的批量回复。

`googlesheets.delete_dimension`

### Delete Sheet

通过 spreadsheets.batchUpdate 删除工作表，并返回稳定的批量回复。

`googlesheets.delete_sheet`

### Find Replace

通过 spreadsheets.batchUpdate 运行查找和替换，并返回稳定的批量回复。

`googlesheets.find_replace`

### Format Cell

通过 spreadsheets.batchUpdate 格式化单元格，并返回稳定的批量回复。

`googlesheets.format_cell`

### Get Conditional Format Rules

读取电子表格条件格式规则，并将其投影为稳定的按工作表结构。

`googlesheets.get_conditional_format_rules`

### Get Data Validation Rules

从所需的最小工作表范围读取电子表格数据验证规则，并返回扁平化的规则条目。

`googlesheets.get_data_validation_rules`

### Get Sheet Names

列出电子表格中可见或所有工作表名称，并包含稳定的名称到 sheetId 映射。

`googlesheets.get_sheet_names`

### Get Spreadsheet By Data Filter

通过 spreadsheets.getByDataFilter 读取电子表格元数据，并返回规范化电子表格载荷。

`googlesheets.get_spreadsheet_by_data_filter`

### Get Spreadsheet Info

通过 spreadsheets.get 读取电子表格元数据，并带有可选范围和网格数据标志。

`googlesheets.get_spreadsheet_info`

### Insert Dimension

通过 spreadsheets.batchUpdate 插入行或列，并返回稳定的批量回复。

`googlesheets.insert_dimension`

### Lookup Spreadsheet Row

查找第一个单元格与查询完全匹配的行，并返回稳定的 found/rowData 载荷。

`googlesheets.lookup_spreadsheet_row`

### Mutate Conditional Format Rules

通过 spreadsheets.batchUpdate 修改条件格式规则，并返回稳定的批量回复。

`googlesheets.mutate_conditional_format_rules`

### Search Developer Metadata

通过 developerMetadata:search 搜索电子表格开发者元数据，仅返回匹配的条目。

`googlesheets.search_developer_metadata`

### Search Spreadsheets

使用仅电子表格的过滤器搜索 Drive 中的 Google Sheets 文件，并输出规范化摘要。

`googlesheets.search_spreadsheets`

### Set Basic Filter

通过 spreadsheets.batchUpdate 设置基本过滤器，并返回稳定的批量回复。

`googlesheets.set_basic_filter`

### Set Data Validation Rule

通过 spreadsheets.batchUpdate 设置或清除数据验证，并返回稳定的批量回复。

`googlesheets.set_data_validation_rule`

### Spreadsheets Sheets Copy To

通过 sheets.copyTo 将工作表复制到另一个电子表格，并返回稳定的 copiedSheet 载荷。

`googlesheets.spreadsheets_sheets_copy_to`

### Spreadsheets Values Append

通过 values.append 追加值，并将嵌套的更新载荷展平为稳定的顶层字段。

`googlesheets.spreadsheets_values_append`

### Spreadsheets Values Batch Clear

通过 values.batchClear 清除多个电子表格值范围，仅返回已清除的范围。

`googlesheets.spreadsheets_values_batch_clear`

### Spreadsheets Values Batch Get By Data Filter

通过 values:batchGetByDataFilter 读取电子表格值，并返回匹配的值范围及其过滤器。

`googlesheets.spreadsheets_values_batch_get_by_data_filter`

### Update Dimension Properties

通过 spreadsheets.batchUpdate 更新行或列属性，并返回稳定的批量回复。

`googlesheets.update_dimension_properties`

### Update Sheet Properties

通过 spreadsheets.batchUpdate 更新工作表的属性，并返回稳定的批量回复。

`googlesheets.update_sheet_properties`

### Update Spreadsheet Properties

通过 spreadsheets.batchUpdate 更新电子表格级属性，并返回稳定的批量回复。

`googlesheets.update_spreadsheet_properties`

### Update Values Batch

通过 values.batchUpdate 写入多个电子表格值范围，并返回稳定的聚合计数器。

`googlesheets.update_values_batch`

### Upsert Rows

按键更新或插入行，同时保留未覆盖的列，在需要时添加缺失的标题，并返回稳定的计数器。

`googlesheets.upsert_rows`

### Values Get

读取单个电子表格值范围，并返回稳定的 ValueRange，不带包装信封。

`googlesheets.values_get`

### Values Update

通过 values.update 写入单个电子表格值范围，并返回稳定的更新计数器。

`googlesheets.values_update`

没有符合搜索条件的工具。

## 将 Google Sheets 接入 Open Flow

[连接 Google Sheets](https://console.openflow.run/connections/googlesheets)

每月 20,000 次免费应用调用（付费服务另计）
