Lorena
Workflows by Lorena
Import data from MySQL into Google Sheets
This workflow queries a table in MySQL and inserts the data into Google Sheets.
Import data from Google Sheets into MySQL
This workflow imports data from Google Sheets into a MySQL database.
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.
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.
Export JSON file to Google Sheets
This workflow exports the contents of a JSON file to Google Sheets.
Import a JSON file from Gmail into a spreadsheet
This workflow imports a JSON file from an email attachment and saves the content into a spreadsheet.
Export CSV file to JSON
This workflow exports a local CSV file to a JSON file.
Collect and label images and send to Google Sheets
This workflow collects images from web search on a specific query, detects labels in them, and stores this information in a Google Sheet. 
Sync data between Google Drive and AWS S3
This workflow [synchronizes files one-way](https://n8n.io/blog/how-to-sync-data-between-two-systems/) from Google Drive to AWS S3.  - **Google Drive Trigger node** triggers the workflow when a new file is added to the drive. - **AWS S3 node** gets all files stored in an S3 bucket. - **Merge node** merges the files from Google Drive and AWS S3 by key (file name) and keeps only the new file. - **AWS S3 node** uploads the new file in the S3 bucket.
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.
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.
Extract and store text from chat images using AWS S3
This workflow extracts text from images sent in a Telegram chat and uploads the images to AWS S3.  - **Telegram Trigger node** triggers the workflow when an image is sent in a Telegram channel. - **AWS S3 node** uploads the sent image to an S3 bucket. - **AWS Textract node** extracts text from the image. - **Airtable node** adds the extracted text and image information to a table.
One-way sync between Pipedrive and HubSpot
This workflow synchronizes data one-way from Pipedrive to HubSpot.  - **Cron node** schedules the workflow to run every minute. - **Pipedrive** and *Hubspot1 nodes* pull in both lists of persons from Pipedrive and contacts from HubSpot. - **Merge node** with the option *Remove Key Matches* identifies the items that uniquely exist in Pipedrive. - **Hubspot2 node** takes those unique items and adds them to HubSpot.
Two-way sync between Pipedrive and HubSpot
This workflow synchronizes data both ways between Pipedrive and HubSpot.  - **Cron node** schedules the workflow to run every minute. - **Pipedrive** and **Hubspot nodes** pull in both lists of persons from Pipedrive and contacts from HubSpot. - **Merge1** and **Merge2 nodes** with the option Remove Key Matches identify the items that uniquely exist in HubSpot and Pipedrive, respectively. - **Update Pipedrive** and **Update HubSpot nodes** take those unique items and add them in Pipedrive and HubSpot, respectively.
Export new deals from HubSpot to Slack and Airtable
This workflow is triggered when a new deal is created in HubSpot. Then, it processes the deal based on its value and stage. The first branching follows three cases: - If the deal is closed and won, a message is sent in a Slack channel, so that the whole team can celebrate the success. - If a presentation has been scheduled for the deal, then a Google Slides presentation template is created. - If the deal is closed and lost, the deal’s details are added to an Airtable table. From here, you can analyze the data to get insights into what and why certain deals don’t get closed. The second branching follows two cases: - If the deal is for a new business and has a value above 500, a high-priority ticket assigned to an experienced team member is created in HubSpot - If the deal is for an existing business and has a value below 500, a low-priority ticket is created. 
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.
Create a Pipedrive activity on Calendly event scheduled
This workflow is triggered when a meeting is scheduled via Calendly. Then, an activity is automatically created in Pipedrive and 15 minutes after the end of the meeting, a message is sent to the interviewer in Slack, reminding them to write down their notes and insights from the meeting. 
Detect toxic language in Telegram messages
This workflow detects toxic language (such as profanity, insults, threats) in messages sent via Telegram. [This blog tutorial](https://n8n.io/blog/create-a-toxic-language-detector-for-telegram/) explains how to configure the workflow nodes step-by-step.  **Telegram Trigger**: triggers the workflow when a new message is sent in a Telegram chat. **Google Perspective**: analyzes the text of the message and returns a probability value between 0 and 1 of how likely it is that the content is toxic. **IF**: filters messages with a toxic probability value above 0.7. **Telegram**: sends a message in the chat with the text "I don't tolerate toxic language" if the probability value is above 0.7. **NoOp**: takes no action if the probability value is below 0.7.
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. 
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](https://docs.n8n.io/nodes/n8n-nodes-base.trello/#example-usage)). Same goes for the *Account ID* in the *Harvest node* (see [instructions here](https://docs.n8n.io/credentials/harvest/#using-access-token)).
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*](https://n8n.io/blog/no-code-ecommerce-workflow-automations/#promote-your-new-products-on-social-media). ## Prerequisites - A Shopify account and [credentials](https://docs.n8n.io/integrations/credentials/shopify/) - A Twitter account and [credentials](https://docs.n8n.io/integrations/credentials/twitter/) - A Telegram account and [credentials](https://docs.n8n.io/integrations/credentials/telegram/) for the channel you want to send messages to. ## Nodes - [Shopify Trigger node](https://docs.n8n.io/integrations/trigger-nodes/n8n-nodes-base.shopifytrigger/) triggers the workflow when you create a new product in Shopify. - [Twitter node](https://docs.n8n.io/integrations/nodes/n8n-nodes-base.twitter/) 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](https://docs.n8n.io/integrations/nodes/n8n-nodes-base.telegram/) posts a message with the same text as above in a Telegram channel.
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.
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
Telegram messaging for bash-dash
This workflow allows you to send a message in a Telegram chat via [bash-dash](https://github.com/n8n-io/bash-dash).  **Example usage**: - telegram I'll be late If you want to send a predefined message without typing it in the command line, you can replace the Text Expression in the Telegram node with a specific message. In this case, the dash command - telegram will send the predefined message to the chat. **Example bash-dash config**: commands[telegram]="http://localhost:5678/webhook/telegram"