Lorena

Templates by Lorena

Import data from MySQL into Google Sheets

This workflow queries a table in MySQL and inserts the data into Google Sheets.

By Lorena

18767

Transcribe audio files from Cloud Storage

This workflow transcribes audio files stored in AWS S3 and stores the information in Google Sheets. Google Drive Trigger node triggers the workflow when a new file is uploaded in Google Drive. AWS S3 1 node uploads the new file to an S3 bucket. AWS S3 2 node gets the file from the S3 bucket. AWS Transcribe 1 node creates a transciption job for the respective audio file. Wait node waits for the transcription job from the previous node to be complete before proceeding with the workflow (necessary in case the service is busy or the file to be transcribed is large, delaying the workflow). AWS Transcribe 2 node gets the information of the transcription job. Set node sets the necessary values to be included in the data set. Google Sheets node adds the transcription information to a sheet that serves as data set.

By Lorena

10567

ETL pipeline for text processing

This workflow allows you to collect tweets, store them in MongoDB, analyse their sentiment, insert them into a Postgres database, and post positive tweets in a Slack channel. Cron node: Schedule the workflow to run every day Twitter node: Collect tweets MongoDB node: Insert the collected tweets in MongoDB Google Cloud Natural Language node: Analyse the sentiment of the collected tweets Set node: Extract the sentiment score and magnitude Postgres node: Insert the tweets and their sentiment score and magnitude in a Posgres database IF node: Filter tweets with positive and negative sentiment scores Slack node: Post tweets with a positive sentiment score in a Slack channel NoOp node: Ignore tweets with a negative sentiment score

By Lorena

9730

Import JSON data into Google Sheets and CSV file

This workflow gets data from an API and exports it into Google Sheets and a CSV file.

By Lorena

8299

Export CSV file to JSON

This workflow exports a local CSV file to a JSON file.

By Lorena

7886

Promote new Shopify products on Twitter and Telegram

This workflow automatically promotes your new Shopify products on Twitter and Telegram. This workflow is also featured in the blog post 6 e-commerce workflows to power up your Shopify store. Prerequisites A Shopify account and credentials A Twitter account and credentials A Telegram account and credentials for the channel you want to send messages to. Nodes Shopify Trigger node triggers the workflow when you create a new product in Shopify. Twitter node posts a tweet with the text "Hey there, my design is now on a new product! Visit my {shop name} to get this cool {product title} (and check out more {product type})". Telegram node posts a message with the same text as above in a Telegram channel.

By Lorena

5285

Import data from Google Sheets into MySQL

This workflow imports data from Google Sheets into a MySQL database.

By Lorena

5248

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.

By Lorena

5091

Process Shopify new orders with Zoho CRM and Harvest

This workflow is triggered when a new order is created in Shopify. Then: the order information is stored in Zoho CRM, an invoice is created in Harvest and stored in Trello, if the order value is above 50, an email with a discount coupon is sent to the customer and they are added to a MailChimp campaign for high-value customers; otherwise, only a "thank you" email is sent to the customer. Note that you need to replace the List ID in the Trello node with your own ID (see instructions in our docs). Same goes for the Account ID in the Harvest node (see instructions here).

By Lorena

4724

Capture leads in HubSpot from Typeform

This workflow is triggered when a typeform is submitted, then it saves the sender's information into HubSpot as a new contact. Typeform Trigger: triggers the workflow when a typeform is submitted. Set: sets the fields for the values from Typeform. HubSpot 1: creates a new contact with information from Typeform. IF: filters contacts who expressed their interest in business services. HubSpot 2: updates the contact's stage to opportunity. Gmail: sends an email to the opportunity contacts with informational material. NoOp: takes no action for contacts who are not interested.

By Lorena

4571

Move data between JSON and spreadsheets

This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.

By Lorena

3639

Collects images from web search results and send to Google Sheets

This workflow collects images from web search results on a specific query, analyzes the image for labels, formats the text, and adds the information in Google Sheets. HTTP Request node gets images from the web. AWS Rekognition node analyzes the images (in this case, it detects text in an image). Set node sets the values necessary for the data set. Function node transforms the text detected in the image to lower case. Google Sheets node adds the image information to a sheet that serves as data set.

By Lorena

3586