Autorial: Part 4. Google Sheets Block - Level Advanced

Introduction

The speaker greets the audience and introduces the topic of "Google Sheets Block" at Automa. They mention that the tutorial will be helpful for repetitive tasks.

Purpose of the Tutorial

The speaker explains that the tutorial will demonstrate how to send emails using data from Google Sheets, potentially saving marketing fees.

Setting Up Google Sheets

The speaker instructs to create a Google Sheet with columns for Name and Email. They mention sharing it with service@automa2.iam.gserviceaccount.com as a Viewer.

Creating a Workflow in Automa Dashboard

The speaker guides on creating a new workflow named "Send emails" in the Automa Dashboard.

Adding Google Sheets Block

The speaker adds a Google Sheets block to retrieve data from the spreadsheet by providing the spreadsheet ID and range values. They also set a reference key and preview the data.

Looping Through Data

The speaker connects the Google Sheets block to a Trigger block and adds a Loop Data block to iterate through each row of data.

Opening Gmail in New Tab

The speaker adds a New Tab block to open Gmail in a new tab, providing the URL. They explain that forms need to be filled out before sending an email.

Filling Out Email Forms

The speaker demonstrates filling out the To, Subject, and Message Body forms using element selectors and attributes. They mention using the looped data for dynamic values.

Filling Out Subject Form

The speaker focuses on filling out the Subject form using an element selector with an aria-label attribute. They show how to include a dynamic value from the looped data.

Filling Out Message Body Form

The speaker explains how to fill out the Message Body form using an element selector with aria-label and role attributes. They mention waiting for the selector before proceeding.

Finalizing Workflow

The speaker concludes by mentioning that all elements should be connected properly in the workflow.

This summary provides an overview of each section in the transcript, highlighting key points and actions taken at specific timestamps.

Setting Up Automa Extension

This section focuses on setting up the Automa extension and performing actions such as typing, clicking, and using "aria-label".

Typing Delay and Thank You Message

• Set a typing delay of 30 milliseconds.

• Type the message "Thank you for downloading Automa extension."

Clicking the Send Button

• The last action is to click on the Send button.

Using "aria-label"

• Use the "aria-label" attribute again for performing actions.

Typing in Editor

• Go back to the editor and type [aria-label="Send ‪(⌘Enter)‬"].

Adding Close Tab with Loop Breakpoint

• Add a Close Tab action with a Loop Breakpoint block.

Specifying ID for Emails

• For the ID, use "emails".

Saving and Executing Workflow

• Save and execute the workflow.

• It will open Google Email and type the first user email, subject, and message body.

• Each email is sent one by one.

Scraping Tweets from Twitter to Google Sheets

This section covers scraping tweets from a Twitter account to Google Sheets using Automa.

Creating a New Workflow - Get Tweets

• Create a new workflow named "Get tweets".

• Add a New Tab block.

• Open your Twitter account or any desired account to scrape tweets from.

• Copy the URL and paste it in the New Tab URL field.

Connecting Trigger Block

• Connect it with the Trigger block.

Adding Delay Block

• Add a Delay block to ensure that tweets are rendered properly.

Loop Data Block for Tweet Elements

• Add a Loop Data block to loop through tweet elements.

Element Selector for Tweet Elements

• Use the Element Selector to select tweet elements.

• Copy the CSS Selector and update the ID to "tweets".

Adding Tweet Column and Time

• Add a Tweet column and a Time column to the workflow table.

Get Text Block for Time Data

• Use a Get Text block to extract the time data from tweets.

• Copy the CSS selector for the date element in Twitter and replace it in the element selector, using loopData@tweets .

Error Handler and Duplicate Blocks

• Enable the error handler with "Continue flow" selected.

• Duplicate the Get Text block to extract tweet data.

Element Selector for Tweet Text

• Select an element with an attribute "data-testid" for tweet text.

• Copy the value of "data-testid" and replace "time" in the element selector with [data-testid="tweetText"].

Loop Breakpoint Block

• Connect it with the previous block.

• Add a Loop Breakpoint block with ID "tweets".

Google Sheets Integration

• Add a Google Sheets block.

• Create a Google Sheets file and share it with service@automa2.iam.gserviceaccount.com.

Summary

In this tutorial, we learned how to set up Automa extension, perform actions like typing and clicking, use attributes like "aria-label", save and execute workflows. We also explored scraping tweets from Twitter to Google Sheets using Automa's features such as New Tab blocks, Delay blocks, Loop Data blocks, Element Selectors, Get Text blocks, error handling, duplicate blocks, Loop Breakpoint blocks, and integration with Google Sheets.

New Section Working with Google Sheets and Twitter

This section focuses on using Google Sheets and Twitter together to update spreadsheet cell values.

Updating Spreadsheet Cell Values

• To update spreadsheet cell values, copy and paste the desired range (A to B column) into the workflow.

• The dropdown menu should be updated to append spreadsheet cell values.

Getting Data from the Table

• It is possible to retrieve data from a table.

Adding a Close Tab Functionality

• A "Close Tab" function can be added to the workflow.

Saving and Executing the Workflow

• After making necessary changes, save and execute the workflow.

Opening Twitter and Updating Google Sheets

• When executed, the workflow will open Twitter and update Google Sheets accordingly.