Google Sheets を Open Flow に接続
Give your AI assistant a spreadsheet link and a cell range to summarize data or write the changes you specify.
毎月 20,000 回のアプリ呼び出しが無料(有料サービスは別途課金)
アプリの説明と操作の詳細は英語で表示されます。
できること
Google Sheets organizes data in worksheets and cell ranges. Connect your Google account to read values, maintain tables, and adjust sheet structure.
Read and Analyze Ranges
Read one or several ranges and calculate numeric column summaries.
Write and Maintain Rows
Append rows, update cell ranges, or match rows by a key when maintaining a table.
Organize Worksheets
Inspect worksheet names, add sheets, and format selected cells.
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
Add a new sheet through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.add_sheetAggregate Column Data
Aggregate numeric values from a target column, optionally filtered by another column, with stable counters.
googlesheets.aggregate_column_dataAppend Dimension
Append rows or columns through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.append_dimensionAuto Resize Dimensions
Auto-resize rows or columns through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.auto_resize_dimensionsBatch Clear Values By Data Filter
Clear spreadsheet values through values.batchClearByDataFilter and return the cleared ranges.
googlesheets.batch_clear_values_by_data_filterBatch Get
Read multiple spreadsheet ranges through values:batchGet and return stable valueRanges output.
googlesheets.batch_getBatch Update Values By Data Filter
Write spreadsheet values through values.batchUpdateByDataFilter and return stable aggregate counters.
googlesheets.batch_update_values_by_data_filterClear Basic Filter
Clear a basic filter through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.clear_basic_filterClear Values
Clear a single spreadsheet value range through values.clear and return the cleared A1 range.
googlesheets.clear_valuesCreate Chart
Create a chart through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.create_chartCreate Google Sheet1
Create a Google Sheets spreadsheet and return stable spreadsheet metadata for the new file.
googlesheets.create_google_sheet1Create Spreadsheet Column
Insert an empty column into a sheet through spreadsheets.batchUpdate with stable top-level fields.
googlesheets.create_spreadsheet_columnCreate Spreadsheet Row
Insert an empty row into a sheet through spreadsheets.batchUpdate with stable top-level fields.
googlesheets.create_spreadsheet_rowDelete Dimension
Delete rows or columns through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.delete_dimensionDelete Sheet
Delete a sheet through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.delete_sheetFind Replace
Run find and replace through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.find_replaceFormat Cell
Format cells through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.format_cellGet Conditional Format Rules
Read spreadsheet conditional formatting rules and project them into a stable per-sheet structure.
googlesheets.get_conditional_format_rulesGet Data Validation Rules
Read spreadsheet data validation rules from the minimum necessary sheet ranges and return flattened rule entries.
googlesheets.get_data_validation_rulesGet Sheet Names
List visible or all sheet names from a spreadsheet and include a stable name-to-sheetId map.
googlesheets.get_sheet_namesGet Spreadsheet By Data Filter
Read spreadsheet metadata through spreadsheets.getByDataFilter and return the normalized spreadsheet payload.
googlesheets.get_spreadsheet_by_data_filterGet Spreadsheet Info
Read spreadsheet metadata through spreadsheets.get with optional ranges and grid data flags.
googlesheets.get_spreadsheet_infoInsert Dimension
Insert rows or columns through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.insert_dimensionLookup Spreadsheet Row
Find the first row where a cell exactly matches the query and return a stable found/rowData payload.
googlesheets.lookup_spreadsheet_rowMutate Conditional Format Rules
Mutate conditional format rules through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.mutate_conditional_format_rulesSearch Developer Metadata
Search spreadsheet developer metadata via developerMetadata:search and return matched entries only.
googlesheets.search_developer_metadataSearch Spreadsheets
Search Google Sheets files in Drive with spreadsheet-only filters and normalized summary output.
googlesheets.search_spreadsheetsSet Basic Filter
Set a basic filter through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.set_basic_filterSet Data Validation Rule
Set or clear data validation through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.set_data_validation_ruleSpreadsheets Sheets Copy To
Copy a sheet to another spreadsheet through sheets.copyTo and return a stable copiedSheet payload.
googlesheets.spreadsheets_sheets_copy_toSpreadsheets Values Append
Append values through values.append and flatten the nested updates payload into stable top-level fields.
googlesheets.spreadsheets_values_appendSpreadsheets Values Batch Clear
Clear multiple spreadsheet value ranges through values.batchClear and return cleared ranges only.
googlesheets.spreadsheets_values_batch_clearSpreadsheets Values Batch Get By Data Filter
Read spreadsheet values through values:batchGetByDataFilter and return matched value ranges with their filters.
googlesheets.spreadsheets_values_batch_get_by_data_filterUpdate Dimension Properties
Update row or column properties through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.update_dimension_propertiesUpdate Sheet Properties
Update a sheet's properties through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.update_sheet_propertiesUpdate Spreadsheet Properties
Update spreadsheet-level properties through spreadsheets.batchUpdate and return stable batch replies.
googlesheets.update_spreadsheet_propertiesUpdate Values Batch
Write multiple spreadsheet value ranges through values.batchUpdate and return stable aggregate counters.
googlesheets.update_values_batchUpsert Rows
Upsert rows by key while preserving uncovered columns, adding missing headers when needed, and returning stable counters.
googlesheets.upsert_rowsValues Get
Read a single spreadsheet value range and return a stable ValueRange without a wrapper envelope.
googlesheets.values_getValues Update
Write a single spreadsheet value range through values.update and return stable update counters.
googlesheets.values_update検索条件に一致する操作はありません。
Google Sheets を Open Flow に接続
毎月 20,000 回のアプリ呼び出しが無料(有料サービスは別途課金)