Google Sheets workflows
185 results — all source-linked n8n references
Extract expenses from emails and add to Google Sheets
This workflow will check a mailbox for new emails and if the Subject contains Expenses or Reciept it will send the attachment to Mindee for processing then it will update a Google sheet with the values. To use this node you will need to set the Email Read node to use your mailboxes credentials and configure the Mindee and Google Sheets nodes to use your credentials.
Save Telegram daily messages to Google Sheets
A goal for 2022 is to write 1 thing I do each day. Combined with this workflow you will get daily messages via Telegram and when you reply to them they will be saved in a Google Sheet. Note: Make sure to configure your Telegram and Google Sheet credentials! You will also need to modify the functions to have your Telegram username and bot name.*
Run weekly inventories on Shopify sales
This workflow is scheduled to run every week, when it gets all your Shopify orders, calculates their sales value, stores the data in Google Sheets, and sends a notification message to a Slack channel.
Transfer data from website to Google Sheets
Take data from website form via webhook and save data into Google Sheets document!
Filter the feedback from Typeform and store in Google Sheets
This workflow allows you to filter positive and negative feedback received from a Typeform and insert the data into Google Sheets. Typeform Trigger node: Start the workflow when a new form is submitted via Typeform Set node: Extract the information submitted in typeform IF node: Filter positive and negative reviews (i.e. ratings above or below 3 out of 5). Google Sheets node: Store the positive and negative reviews and ratings in two different sheets for each case.
Monitor changes in Google Sheets every 45 mins
Based on your use case, you might want to trigger a workflow if new data gets added to your database. This workflow allows you to send a message to Mattermost when new data gets added in Google Sheets. The Interval node triggers the workflow every 45 minutes. You can modify the timing based on your use case. You can even use the Cron node to trigger the workflow. If you wish to fetch new Tweets from Twitter, replace the Google Sheet node with the respective node. Update the Function node accordingly.
Move metrics from Google Sheets to Orbit
Moving metrics from Google Sheets to Orbit
Send Instagram statistics to Mattermost
This worflow let us know main stat on our Instagram : this is the first i share with community as i am a beginner :) Every morning i know how many follower we have, how many posts have been made. I use a fantastic tool which is : https://socialblade.com and also : https://martechwithme.com/monitoring-youtube-channels-subscribers-with-google-sheets/ to send them to Google Sheets Hope this could help :) This can be improved for sure, so i will be very pleased to have your comments thanks French version : :) * Ce schéma permet d'avoir les statistiques de notre Instagram : combien de followers et combien de posts ont été réalisés. Ces données sont publiées sur MAttermost. J'utilise un outil génial pour récupérer les données de instagram : https://socialblade.com puis https://martechwithme.com/monitoring-youtube-channels-subscribers-with-google-sheets/ pour les récupérer sur Google Sheets
Send bulk messages to chats in Telegram
The Telegram API has a limitation to send only 30 messages per second. Use this workflow to send messages to more than 30 chats in Telegram.
Automated congratulations with Google Sheets, Twilio, and n8n
Explore this workflow on its official n8n template page.
Send feedback from Google Sheets to Mattermost
n8nConf Companion workflow for blog post
Transform data in Google Sheets
This workflow appends, lookup, updates, and reads data from a Google Sheet spreadsheet. Set node: The Set node is used to generate data that we want to add to Google Sheets. Depending on your use-case you might have data coming from a different source. For example, you might be fetching data from a WebHook call. Add the node that will fetch the data that you want to add to the Google Sheet. Use can then use the Set node to set the data that you want to add to the Google Sheets. Google Sheets node: This node will add the data from the Set node in a new row to the Google Sheet. You will have to enter the Spreadsheet ID and the Range to specify which sheet you want to add the data to. Google Sheets1 node: This node looks for a specific value in the Google Sheet and returns all the rows that contain the value. In this example, we are looking for the value Berlin in our Google Sheet. If you want to look for a different value, enter that value in the Lookup Value field, and specify the column in the Lookup Column field. Set1 node: The Set node sets the value of the rent by $100 for the houses in Berlin. We pass this new data to the next nodes in the workflow. Google Sheets2 node: This no
WAdd data from a photo to Google Sheets
Automatically adding expense receipts to Google Sheets with Telegram, Mindee API, Twilio, and n8n.
Insert and read data from Google Sheets
Companion workflow for Google Sheets node docs
Gather leads in Google Sheet and Mailchimp
Gather leads into Mailchimp, automate marketing, and sales process.
Receive Google Sheet data via REST API
Simple workflow which allows to receive data from a Google Sheet via "REST" endpoint. Wait for Webhook Call Get data from Google Sheet Return data Example Sheet: https://docs.google.com/spreadsheets/d/17fzSFl1BZ1njldTfp5lvh8HtS0-pNXH66b7qGZIiGRU
Sync data between multiple Google Spreadsheets
Triggers workflow all two minutes Reads data from a Google Spreadsheet (in example Sheet Data columns A to G) Write the data unchanged in two different Spreadsheets with same Sheet name and columns, expressions are optional)