How to automate tasks with AITable.AI in ActivePieces (SUMMER 2024 EDITION) 🤖

hello YouTube Friends welcome back to my channel my name is Dennis and in today's video we're going to be doing a remake of my video that I created six months ago in this channel it's called how to automate task with a. it's a video that a lot of people has been asking me to redo or to remake because of the video quality in this video was terrible back then I apologize so I figured I would create a new video for you guys in today's video and it's going to have the new and the latest features that AA table has introduced since I created that video so hopefully this is two times better than the original so hopefully it will help you out and it's much better quality than the original one so so yeah I going to recreate this video and first thing I want to do is I want to cover what a table. a is so if you're not really familiar with what a table is it's essentially spreadsheet type of application where you can create records similar to Google sheet and some of the special platform that is so the main competitor for a table is air table so you get a lot of similarities in that front for what the platform has to offer so let's go ahead and take a look at what a table is if you're brand new and have no idea what a table is I'm just going to go through and just kind of explain a little bit how it works so you can create organize your data using AI you can do some collaboration with it as well since you can create your space and you can have a data sheet that you can collaborate with other people you can also do some automation as well it has a built-in connection with zapier make probably active pieces ALB some of the major API tools available that's out there they do have an API offering as well which allows you to integrate with a table from other applications or platforms not just the tools that I mentioned here so which is pretty cool so it allows you to have some flexibility if you want to build it and include it in your application so that's also a possibility and something that you can do since it has the built-in API integration all right so there's also a bunch of different things as well there's some data transformation there's also some forms where you can allows you to submit data from within your internal users or you can also share uh a form that can be accessed by a public user or an anonymous user I'm using it a lot for some forms that I want to have user submit data for for instance like a newsletter to gather some list or email list so there's a lot of use cases as far as utilization of form and what you can do with it you can also build your AI agent chatbot which allows you to train your chatbot or agents based on your knowledge base that have you created within your data sheet before we get started in this video I want to do a rundown of all the things that we're going to be covering in this video uh we're going to be covering the basics of a table. uh in relation to uh doing an an automation with active pieces we're going to be covering the basic basics of a table with focus on the automation aspect of it I'm going to be showing you guys the basics just in case you're new to a table and you're trying to be productive with getting started on the tool so I'm going to be showing you guys ins and out including the different field types that is in a table we're also going to be covering some of the formulas there's quite a bit of formulas in AA table so we're just going to be focusing on the basics as what can be useful for automation aspects we're going to be covering some of the a table automation as well uh if you don't know already there's an automation feature that is built in with a table and it's something that you can use to also do some automation with so we're going to be covering some of that as well as kind of show you to get familiarized with that aspect of it so you can have that as an option if you want to do an automation that way with an a table in today's automation we're going to be creating an RSS aggregator where we're going to be scraping uh used articles from an RSS feed we're going to be taking those that URL that we get from an RSS feed and then we're going to be doing a web scraping uh using fir craw if you're not familiar with fir craw is essentially a platform where you create a markdown a or structure data based on that website so you can do a web scraping on either the entire website or a single page so I'm going to be showing you guys how to set it up so here's a very basic example of it so it gives you a structure right here where it gives you an array of all the different pages that you scrape if you're trying to web scrap the entire website but I'm going to be showing you guys in details how to set it up including setting up and accessing their platform using an API and integrating it that way so we're going to be integrating and setting it all up within active pieces so here's what we're going to be building up today which is this automation right here we're going to be taking in an RSS feed and we're going to be pulling the data which we're going to be capturing the URL we're going to be web scraping the data using fire and then we can feed it into AI so that we can clean up that content which we're then we're going to be storing inside a table so that's going to be what's in store today okay let's let's walk you through the uh the flowchart that I've created here so you can kind of see the relationships between the different features or different things that you can add inside your a table so for instance right here on the top which is the data sheet which is the basis for all the different things that you create inside a table so think of uh data sheet as the spreadsheet you can create uh multiple uh views inside of a data sheet uh you can also create a new data sheet based on next system templates uh templates is package uh set of things uh inside of a table uh including a view uh including a form including a widget anything that you can take off you can package it into a template that you can create a data sheet with so it contains all the different columns or different fields that you can use within your app and so you can get started with creating workflow whatever the template is designed for so for instance if you're creating a data sheet based off an existing CRM template right and you don't want to create a new CRM from scratch you just want to create from an existing one you can do that and then you can just customize the the data sheet that's been created based on your preference once you've created the data sheet so that's how essentially how it works in conversely you can create a template based on existing data sheet so a you can create a template from an existing folder that that contains a data sheet and some views and some charts or whatever and then you can create that into a template so that you can use that to create uh other workflows you can create it in the future so let's say you want to recreate the same type of flow or workflow for your organization again again in the future so you have to worry about creating everything from scratch that can be useful for that as well so let's go ahead and take a look and dissect some of these things in more details so from a data sheet you're given a grid view or view by default which is the view that you you start start off with when you add a data sheet and from here you can modify it you can add columns or fields and you can sort it however you want and you can create multiple views as well which I'm going to be demonstrating in a little bit how to do the next thing that you can do with a data sheet is you can create an AI agent so with AI agent you have two options the first one is a chat agent which is if if you're familiar with chat gbt it allows you to do a generic type of queries and responses so you can ask any type of generic questions and the llm depending on what llm you choose it's going to provide answer in a trained data set or whatever that llm is trained on so that's what a chat agent is a QA agent is a little bit more different as is specific to the content the AI agent is trained on so you can train it based on your data sheet uh content and it's only going to pull the data based on the the content that you provided which is inside of your data sheet it can't really pull any response outside of the trained data this is why it's called Uh QA agent so from here you can see here that the QA agent is an AI agent powered by the rag or retrieval augmented generation technology and it excels in providing efficient question and answer service by combining informative or information retrieval and natural language uh generation techniques so that's what it is okay so going back to the data sheet within data sheet you can create a a form where it allows for an internal or external users to submit a new records into your data sheet uh you can create a form based on uh whatever field sets that you have or you want to be available as part of your form uh you can customize your form uh however uh you may see fit based on the fields that you have on your form and you can customize it you can add uh branding and so on so forth uh I'm going to be showing you guys here in a little bit how to customize and create a new form as well we're also going be highlighting the automation aspect inside of a table so if you want to create uh your own automation within AI table you can also do that so I'm going to be showing you guys how to set up the automation within AI table not as uh inside active pieces so you have some flexibility and different options if you want to create either your automation within a table or within active PES and lastly I'm going to be showing you guys uh in a little bit I'm not going to go into too deep into the widgets but a widget is essentially a new feature that they introduced that allows you to visualize your data they also have a script widget which I'm going to be discussing in a little bit on how to use which essentially allows you to modify your existing uh fields and columns based on set of criteria so let's go ahead and take a look in a bit more details the basics of a table all right so let's go ahead and take a look at what we're going to be building today so I've created this data sheet and an agent within AA table you can see here I have an agent right here and also some forms and some agents so we're going to go ahead and take a look at this in a little bit just to kind of show you what we're going to be building today so I have the title of the article here the source URL which we're going to be uh pulling from this RSS feed and we're going to be including the date publish and also the most important piece of this is we're going to be grabbing the content as well so let's go ahead and take a look at one of these script content so you can see here that based on this URL right here we're able to just extract the main contents of this article and removed all the different HTML fragments that associated with usually when you scrape contents we were able to remove the HTML fragments that are usually associated with web scraping websites and articles so we're able to extract some of the the article details so using an ai ai prompt and feeding it into AI we're able to extract just the main uh content uh of the article and we were able to remove all the different uh parts of the article that was not really relevant to what we want so we're able to extract this information so that's what we're going to be building today we're going to be building everything in active pieces so just to kind of show you what we're building today I'm just going to give you a high level before we jump into any thing just to kind of give you a taste of what today's video is about so we're going to be pulling the news from the RSS feed and then we're going to be doing some checking within AI table which we're going to be using the filters so you can have an idea how to use filters and AI table and then we're going to be uh grabbing the URL which going we're going to be creating different sets of we're going to be using a lot of code in this video just to create and grab the URL of the RSS feed uh a lot of these uh news feed special Google News are using a some sort of redirect so uh we're using some code uh to essentially get and retrieve the URL for that for their website and then we're going to be using firec if you're not familiar with firecall essentially a tool that allows you to do a web scrape on a website whether it's a single page or for the entire website and it gives the the data or the content back in a structured data format so that's what we're going to be using today to do web scraping and this code right here is I'm going to be showing you guys in a little bit how to set it up so you can understand it and how to use it and learn how to use it within your own automation scenario and then from there we're going to be do some validation as well and then we're going to be using stco to essentially extract uh the data and the main key points from the article that we've scraped so we can clean it up without having any of the uh necessary uh content that's usually available when you're doing a web scraping on a generic website this type of automation can be used for any type of data regardless of uh whether it's SP world or it's whether it's structured in a specific way so this is essentially going to work with any website that you can think of that you want to do a web scraping on and then lastly we're going to be storing those data that we scrape from the RSS feed using firecall and Ai and then we're going to be uh storing that in AI table all right so rather than going through the documentation as want to do a Hands-On demonstration so can you you can learn how to use a table in a in a more practical sense so let's go ahead and take a look at uh a table here so when you first log into a table so this is essentially what you're going to see you're going to have the the teams and the the pins right here right so you're going to see all the different uh nodes this is what a table refers to when you say a node a node can be anything it could be a data sheet it could be a view it could a dashboard or form so that's what a a note is about so let's go ahead and and start from the beginning here and take a look at explain what this space is about so when you first create an account you're going to be given one space and you can have up to 10 space when you create an a table account are you given one space and from here you can click on the top left hand of the the website here and you can see here that I have access to these spaces I have one out of 10 so I can create multiple spaces here so a space is a way of adding organization to your own account so for instance if you have an account or a company that has multiple departments you can think of each department as a space where multiple individuals can be working in a single space that they only have access to and obviously you can have different users allowed for that space by modifying their permissions and inviting that user to another space similarly you can also join additional spaces here as well which your join space is going to be showing up here so if I've joined or someone invited me to their space I'm going to be able to easily just switch to that space quickly by clicking on the space that I have access to here so you can see you're going to be seeing the spaces here so let's go ahead and just start with my space and each space has its own allocated a numbers of nodes uh and things that you can do with it so whatever your plan is is going to be limited based on the space that you have so each of those limitations is going to be within a space so how many noes can you create or how many records can you create per space is on a space level okay next thing that we talk we can talk about is the add button here so if you want to create uh a data sheet you can create a a new data sheet up here by clicking on this add button uh you can also uh add a new form as as well as some other stuff such as dashboard and some agent some of these things relies on a data sheet to get started so if you don't have any data sheet you will have to create a data sheet for you to create a new form or or whatever that you need to create here including a custom page you can also import from an Excel so if you want to import some of those columns and data from an existing Excel or CSV type of file then you can click on this import from Excel as well here's what I was talking about where I can create for a temp template so you can create a new data sheet here from an existing template so you can create it from here or you can also click on this templates right here where you'll see all the available templates that's available for you so that you can use to create your workflow so you can be productive when using a table so you can see here the there's different uh categories that you can choose from uh there's the hot recommended where you can see here the different uh templates that I'm guessing is uh popular among the users that people are utilizing more so you can see here the uh product release plan you can also see here that there's a Content M marketing for SEO uh so if you click on one of these for instance the content marketing for SEO so you can see here that it already has a folder so this is a folder right here on the top level you can see here that there's a folder which is content marketing for SEO and you it has a built-in dashboard which is pointing to an existing data sheet it also has a the data sheet here as well which includes all the different fields that you see here including the content topic the related SEO keywords publication platform and so on so forth it also has the Gant chart view as part of this data sheet and it Al has a Canon board which I'm assuming is for managing the content when you have an SEO agency or when you have an agency that's focused on SEO so you have a Content Canan here and you also have a gallery view so if you have an image uh that you're embedding as part of your data sheet uh you can easily view those uh images uh based on this uh gallery view that they provided so there's another uh view here which I'm assuming is a separate view which is SEO Q uh keywords and also another data sheet which which is I'm assuming is tied to the other data sheet that you've seen so we can go ahead and take a look at this one by using this template so let's go ahead and and click on use templates and we can add this to either the team space or we can add this on a private so let's go ahead and add it one option that you can see here that you use a data in the template so by default you can use an existing data that they've provided or you can start from scratch when you create a data sheet based on an existing template you can have a basically an empty data sheet with no data in it so what we're going to do here is we're going to use a data in a template so we can have some data to work with and have the dashboard pre-populated with data so we can see the different visualization tool that's really been added as far as this template so let's go ahead and click okay after a few seconds you get here a folder which gets added inside of my space so you can see here the same one that we've seen in the preview you can see here that there's a a folder right here with an icon so if you want to change the icon for a folder you just click on this icon right here and this will allow you to pick from an existing set of icons that you have available you see here I have an icon right here you can do a search um uh writing for instance and this will bring up the writing icon that you can attach to this so that's how they were able to to change it so if you want to change it to something else such as this pencil right here I can just go ahead and change that to a pencil so we can open up this folder by clicking on this icon on the left hand side and you can see here we can inspect it by going through each one you can see here that this consist of a dashboard that consists of multiple widgets as part of it you can see here that each of these uh widget can be configured uh separately you can see here what uh what type of uh data can be shown in this widget and also what type of description uh can be can be set here you see here that this is set to count records based on this competition level as a data source you can see here that there's different data sources that you can pick from so that's the dashboard right here and the next one would be the the grid view or the view right so you can see here that this one has been named to all I'm assuming this is unfiltered version of the data sheet where you can see all the different entries and then you can switch to the same data sheet but within a different view you can see here that there's 10 hidden Fields within this Gant chart view you see here there's 10 hidden fields and then you can also there's also some hidden graphic field here as well so you can see here that only the content topic personas status and content type has been enabled for this View and then there's 10 hidden Fields you see here all the different fields that's been hidden there's no there's no filtering or anything on this View and you can see that this there's some also some settings that you can configure as well if you want to select uh based on what dates uh to to do a Gant chart on uh moving along let's go ahead and go to the canb can band view uh which is a way of uh organizing in your content so that uh you can move uh the different records into different states uh within your within your view you see here there's like multiple status and you can drag if I want to drag this content across and move it to a researching State then I can just drag this and see here that now the short-term rental is within the researching state for this Canen board next thing we're going to look at is the gallery view you see here that the gallery basically has all the information each of the records within this data sheet has a image associated with it you see here that we can inspect it if you go to all let's go and inspect one you see here there's like an image attached to this one right here to each record there's also a checked image as well which we're going to be talking about in a little bit but just to kind of see like all the different things that you can add in the template can consist of all these different variations and different views that you can add to it so it will just have all the different things that you need to get just get started all right let's go ahead and take a look at the different fields that you can use within uh a table let's go ahead and look at the the data sheet here which has all the different records okay so the way you can add a data sheet is within a folder you can create a data sheet from there so let's go ahead and start from the beginning so you can have an understanding of this so within this folder I can go ahead and do click on this plus and I create a new data sheet and from here I can just rename this to something else for instance uh test data sheet so this could be anything that you want by default you'll be given this field name of title right options and attachments so you have to kind of think about this beforehand when you first create your data sheet you have to make sure that you have to kind of think this through because the First Column is going to be your unique column right so when you first uh create a a new data sheet you're going to be given this title and you can name this whatever you want we can also change it to a a different field type all right you can set whatever settings you want but the only problem with this you can't really move this around right so this is really uh static at this point uh you can only change the name and the type but you can't move this around so you have to make sure that you kind of think this through and what you're going to be adding when you first uh create this data sheet so in our case the title is fine you can have it as an ID as well if if you want to have it a unique uh identifier for this uh record right so so that could be that or the title let's goe and and make this a title again and I made this a single line text so aside from single line text which is obviously for single line type of text you can use single line text for a very short uh type of text but if you need to use it for for big paragraphs or for long type of contents then you need to switch to a long text another one that you can also use a is a number if you want to limit a user to use a specific number with certain precisions and units of measurement then you're going to use a number same thing with currency if you want to just put a constraint and to only allow currency information within a field then you can change it to currency there's also the percent and there's also a date as well where you can set it to use a time zone right you can do a 12-hour format or 24-hour format and you can also use your existing time zone if you want to use a specific time zone you can use you can set it as well you can see here that I can display the time zone when I create a date within this field another thing that I can also toggle is when if I want to prefill this with information every time I create a new record so this will be like a timestamp information so I can also toggle this option right here where where I can autofill uh creation time when record is created there's some other setting here as well which I'm going to be discussing when we get to the forms section of this video but those are the options that you get when you have a date field type the next thing that we're going to be looking at is the URL so the the URL is a very unique one where it allows you to add a URL and then you can use that to navigate to the website pretty easily I don't really use this as much I prefer a single line text for for URL type of scenario as it kind of does the same thing it doesn't really over complicate it but if you have a need to just format your url a certain way I think this will be a good approach like I mentioned a single line text would suffice for some of the URL stuff a phone number if you want to limit the field to a phone number same thing with an email so you just limit whatever can be set onto this one so the next one is the Auto number like I previously mentioned you can do like Auto number so if you specify this field right here as an ID you can have an auto number here where it is going to generate an automatically generate number for you every time you created a new record so every time you create a new record it's going to be this field it's going to autop populated with that ID right so that's that for the Auto number that you can use and also the formula which we're we're going to be discussing in a little bit so there's numerous amount of formulas that you can use with an AI table mostly for displaying and and calculating purposes but you can also use formulas within active pieces for filtering purposes which I'm going to be showing guys a little bit how to do a filtering so that you can only retrieve certain records that fits that based on that formula they provided so there some of the formulas that you can use such as sum where you can uh do a a sum of all the different colums that you have uh within a record uh average where you can you can pass in multiple uh fields or columns and it's going to take an average and it's going to just put that in in a single field other things that you can can be useful here is the main and Max if you want to get the minimum and maximum the run up the the even odd converting to a number for instance if you want to do that um there's also one here where you can convert a string to a number that can be useful as well concatenate so this can be useful if you want to concatenate a string when you want to combine certain strings for instance if you want to combine first name and last name and so on so forth that can be useful for that so fine is if you're trying to find a text or a string within a text and then it's going to be based on the the location of that so if you find anything that's going to be greater than zero otherwise it's going to be zero same thing with a search okay so search is similar to find except that if you do a search and if you don't find anything within a a a text you just basically going to get an empty string as opposed to getting a result for it if you want to get a length of a column or a field if you want to get the how many characters you can grab a number of characters from left or right you can use the left and right upper uppercase lower case getting converting or checking if a an argument is a text can be handy so for instance if if you're trying to determine whether a number is a string type of value then you can do a check so there's a lot of function here like the if statement which the if logic is very useful if you're trying to trying to get a value so for instance if you're doing a if else type of logic where if this is a number is greater than zero then you can return a string and then otherwise it's just going you can default it to something else so there's a lot of things here that you can do there's some date functions where you can grab the B date you convert uh the date you can determine how many days from today's date you can choose a lot of these function you can extract the year get the month get the day get the hour get the minute get the second so all these different things that you can do within right and obviously you also have access to the record ID which can be useful if you're trying to automate where we can easily uh pull the record information based on the record ID so all the records within uh a table has a unique identifier which is the record ID if you want to just pull a single record within a table for specific based on the ID then the record ID would be something that you're going to be using for your automation so that's that for for the different fields so one thing I also want to cover is the attachment you've seen it earlier in one of the data sheets that was included as part of the template we're able to attach an image right here so you can see here that I can attach an image so you can essentially use a table as your content management software so if you want to use this for keeping track of your blog contents for instance this can be useful for that as well so if you're managing a content if you want to store your feature images if you have different images within this you can store um multiple attachment and this could be something that you can use to store uh your blog content in right so aside from uh the content type you can also uh set the status uh you can also set this to a a user within uh your space so you can see here that I can attach uh myself as a writer for this record uh same thing with the the work do for instance there's a deliverable field right here which is a work do so this is a no notion alternative to if you're used to managing your content within notion so this give you a similar feel of similar to a notion database where you can type in your text or your heading and then you can have you you can do a forward slash and it will give you a rich text type type of format where you have your paragraph and also you can include a heading right so you can have a heading right here heading one and then you can have your uh additional text here as well so a lot of the things that you can do uh within notion you can do here such as image you can you can embed a video and image as well um as well as you can embed a code block so if you have you have some documentation that you want to do you can also include a code block here so so you can easily just identify the code uh pieces of that uh particular documentation that you're trying and create there's also the divider this code to-do list which is kind of cool you can do a to-do list here we can do a check so you kind of visualize like what the things that if you want to do a visualization of the rich content that you're attaching as part of this record so you can go further and enhance it by adding this workable docs that's within here so from here you can get out of this one so the next thing we can look at is the automation so the automation is built in for each of the data sheet if you click on this top right right here where it says automation you can create an automation for each data sheet so for instance right here I can create a new automation by clicking on that Automation and then from here you can have the same type of logic or type of if this in that type of scenario where you can add a trigger and then within a trigger you can also add additional action on top of that so for instance if you want to add a trigger you have this all these different options right here so when a form has been submitted you want to create an action based on that specific trigger when a record matches a condition which is where you can set it to a data sheet and then you can set a specific type of criteria so for instance here I selected this data sheet right so when a Content or specific whatever field uh that you choose contains a specific data or information you can trigger this automation to do just that based on this type of trigger and then from here let's go ahead and take a look at the other ones as well when every time you create a new record you can do an automation on top of that as well and then uh lastly here you can also do a schedule base so a schedule base is the same thing with active pieces where you can create an automation based on a schedule basis so if you want to do an automation on a daily basis or if you want to do per hour or per week or per month whenever you decide to do automation for this you can set a schedule for this and this is going to be deducted based on the plan that you have in your account so however many automation that you can do per month is based on the account that you have so from here once you have the the schedule in place let's say I chose this automation schedule based on starting from January every month or every day right so if I do a schedule every day starting at uh midnight you see here that it even tells you when is it going to come up next when is it going to happen next it's going to give you a preview of of when the auto the automation is going to run next right it's going to be UTC minus 7 and then then from here you can add then action this is what you want to happen when a specific trigger has occurred so if this schedule arrives you want to then do some automation on top of that right so for instance in this case AI table has a few options they do have a send web request send message to slack send emails and then there's like different option apps here that has been added as well if you're familiar with these tools you can do that so you can just send a web request right here which then allows you to send make an HTTP call to a web hook or an API of you're choosing so it could be an active pieces or it could be it could be anywhere you can change the request method to get post patch and delete so the most common request method I think the put is the only one that's missing here but you have all the different request method that that you need uh to enable this web hook and then from here you can specify your request address which is the web hook uh URL and then lastly here you can include a header as well if your API requires some sort of header or type of authorization to be part of that request you can also include that value here so you can type in authorization right if you want to do authorization request and then bear token and then you can include your API key if you have it so that's how it works as far as automation is concerned so far we talked about the automation we've talked about the uh different field types uh the templates let's go ahead and take a look at the widgets here so by clicking on the widget next to the uh automation in the API you can create a widget all right so based on this data sheet you can create a new chart you can create a summary widget uh pivot table a funnel chart you can also import your data sheets uh from Air table so if you're coming from Air table and if you're trying to migrate all your existing data and Fields into air T AI table then you can install this widget which allows you to basically migrate everything we can also migrate from uh Excel spreadsheet so whether you have an X XEL uh spreadsheet or XLS or CSV files you can add it and import it to your your current table so you can install that widget here uh you can install a chart here you can see here that there's some visualization tool that you can include as part of this so you can see here that once we added that chart widget you can see here that there's a visualization that comes up on the right hand side uh you can see here that uh the chart is essentially set to the the title or the content topic that you have here on your data sheet so you can modify this and you can configure your chart to essentially just point to any type of data that you have within that data sheet you can configure the x axis and you can configure a y y AIS right you can kind a field You Can Count a field or count on the records that you have for that particular title in this particular case so you can configure this however you want so that's an example of how the widget looks like uh there's also also a special widget here that you can also include so you can see here that you can add multiple widgets into a data sheet here you see here that I have a summary here some pivot table if that's something that's useful to you special one that I've I just kind of recently learned while navigating a table is this thing called Script which is considered a widget within a table so you can see here that you can attach a code which looks like it's fun so you can edit this code and you can run it so by default right now you have a default output right here which you can use for debugging purposes if you want to the output of the contents within your data sheet for instance so you can see that you can do a programmatic widget where you can calculate certain things you you can have finer control of what you can do within the different fields that you have within data sheet based on certain criteria you can set a field to a specific type of text by running this the script widget so which is kind of looks like it's fun so you can see here that I'm able to do a hello world here so just a simple script that we have here I'm probably going to be doing a separate tutorial on this specific feature as this is going to outside of the scope of this video but just to kind of show that this is option is available for you to use within a table within a data sheet so you're going to go ahe and expand this in this one you can create create a setting so from here you can rename a widget you can create and and send the information here to a dashboard if you want so let's go ahead and close this one so that's what a widget is the next thing thing that I want to highlight and focus on is the form so let's go ahead and take a look at the form so you can create a form within a data sheet here so you can see here based on this view I can create a form right so let's go ahead and create a form from this view so you can see out the box when you first create a form out of an existing view of a data sheet you're going to see all the different fields that you have available for that form so the only way to limit the different fields that you can show on the form is to create a different view with a specific list of fields that you want available to your form so in this case I can send this form to someone and have someone fill out this form right if you're happy with the form that you see here you can end it from here once you're satisfied with this form you can also modify the settings right so you can remove on the covers you can see here there a there's a cover on the top you can remove that or you can modify it according to your branding if you have a certain brand that you want to add here so if you want to remove it you can remove it um you can also add a logo here uh I can also remove it I can also remove the index here you see that there's an index for each field uh we can go ahead and remove that as well if you just want to clean it up and there's also the branding which at the bottom you can see here that there's a branding powered by a table. which you can also remove so you see are the different options that you have right now it's probably not the ideal form that you want to send to your user because it contains all the different form fields and options that that you have in a particular data sheet so in order for you to clean this up so I'm going to go ahead and remove this and confirm it so let's go back into my content management so I want to create a new view based on this particular data sheet so let's go ahead and create a new view so like I previously mentioned you can create multiple views on top of a data sheet so by default you get this all or default grid view right here which you can then further customize so let's go ahead and create a new view here that we can use for our form so let's go ahead and add a new grid view here you see here that I can do a plus view and then it's going to go ahead and create a new grid view which is then name a grid so I can name this however I want so I can go ahead and click on this one and name it to something else I can name this to view form view which I know for a fact that I'm going to be using this specific to view which is the reason why I renamed it to that form view so now from here I can hide fields that that I don't want to be visible in inside my form right so I can remove certain things such as for instance the related SEO keywords I want to remove that from The View I also want to remove the Persona I want to remove the Persona maybe the status I don't want the status to be there and also the writer maybe the head header image can also be removed need other image and then I don't want the different dates to be available so I just want to be streamlined as possible when I'm giving this form to someone I just want the the different fields that I want the user to be able to submit and remove the other fields that I don't want to be submitted by the user So based on this form view I can go ahead and create a new form based on this one so I can either create it from here right so I can either create from here and add a form which I can then point to the form view that I just added right so from here I can just create a new form so now when you create this new form now it's tailored against the form view that I created which is have all the different fields just set for this specific view so now I can do the other settings that I want such as to remove the end removing The Branding and I have the form that I can basically send to someone so all I have to do is just share this to to another person and create a public link and this will be available on this uh URL right here so anyone who has access to this form can basically just submit uh this form anonymously or they need to log in to submit so you have different options here how you want the user to be able to submit data to this form you can also limit how many times a person can submit to this form right so you can if you're enable need login to submit you can also enable how many times they canot submit right so you can either submit you can have a No Limit type of submission or you can have a submit once only type of submission so which is kind of cool and then from here here anytime you create or change the field settings it's going to be reflected on the actual view that this form is set to so for instance for the cont content type if I change this to a type for instance this is going to change the actual field name into the original view just in case you need to change the field name just to keep in mind that whatever you set the field name here is going to be reflected in the actual view that you created for the status sheet so just to prove that let's go ahead and change it and let's go back to content management and let's go back to form view you see here the type has been converted change to type not content type next thing I want to cover is API so you can see here when you're working against a data sheet each of the data sheet that you're working on allows you to communicate to it via an API right so here you can see here that I can click on this API which brings up this API panel so here from here you can see all the different fields that's available for this view so if I want to go back to a different view where which has all the different fields I can go ahead and click on the API here as well which will toggle and bring all the different fields that's available that I can use and consume within that endpoint so from here I can get multiple records right I can do some pagination or I can well gives you some data here right so when you make a request to this endpoint you can see here the different things that it it returns such as the type of the code what whether the message has been successful or the retrieval has been successful also the amount of that's within the amount of records that you're retrieving the page number page size and all the different records with the record ID and the all the different relevant Fields within this Row Records so you can also add records as well in this API update records delete records and also upload attachments as well as you're working through this you can see here on the last tab where it says upload attachment you can see here that there's different sdks that you can use so within curl obviously you can create a a regular HTTP request where you can pass in your API token you using this command you pass in your your form data and then you you're passing your your path to your file so that's how you upload it uh another uh way you can also do this is using the SDK that's available in JavaScript as well as well as python which they give you some code here to allow you to upload an attach M and attach it to your to your record right that's how you work with a table through an API and this is available within active pis so you don't have to worry about having to deal with having to work with API and having to know how to make a request via an API to access the AA table within active pieces so everything's available for you via the AA table piece that's available already so that's that for the API and something that you can use if you're working with a sep separate app right if you're SE you're using an app outside of active pieces or make or zapier you'll need obviously you'll need API access which you do have access to when you create a data sheet just to something to keep in mind so last thing I want to talk about in a table before we do an automation is let's go ahead and take a look at the organizational structure here so you can see here by default when I created a data sheet based on an existing template you can see here that there's a hierarchy right so there's at the top level of the space I have this content marketing for SEO it created a folder on the The Parent Directory of that space if you want to organize content or nodes in a certain way I can be more complex as I can by adding folders inside of that folder so I can go ahead and create a new folder here so let's say I want to create a new folder within the content marketing for SEO let's say I want to do a child folder so you can create all these more complex organizational uh structure within uh a table uh and you can have different uh things organized in a certain way so if you have a way of organizing your things for instance if you want to use this for a second brain for instance like you want to store your contents here you can create multitudes of folders within a folder right so I can I can even create from within a child folder I can go ahead and create another folder within that and that can be a child folder child folder too for instance and then from here you can create and include additional folders and additional nodes underneath this folder that you created I just want to touch on that and how you can organize your space a little bit more by adding these multiple folders and obviously by clicking on on the left hand side you can add icons specific to that folder so you can easily identify that folder just kind of looking at it from when you first open up your space you can easily identify what that folder includes and so on so so forth all right so the last thing I want to touch on here is to create an AA agent so so let's go ahead and create an AA agent based on the SEO keywords or content management table right here right that I created so underneath this content marketing for SEO let's go ahead and create an AA agent by doing a plus here and then we can do a new AA agent right here which which is still in beta at this point you have two options one is to create an QA agent where is like I previously mentioned is a QA type of response uh type of AA agent where the the agent is going to pull information from the the content that's available within your data sheet versus a chat where it's just going to be generic type of a agent where it's going to be trained on data that's not really specific to your content so that's the major difference between these two depending on what type of style of agent that you're trying to create let's go ahead and take a look at a agent inside a table keep in mind that this feature is still in beta it's still not a fully flushed feature so that's something that you need to keep in mind when you're working with this feature within AI agent but let's go ahead and take a look so within YouTube demos I have another folder here called AA table which has the AA news which we're going to be using in the automation today so you can see here I have the title The Source URL the date publish the content and the email so let's go ahead and take a look at the title real quick so the title is a single line text which is identifying the article that we're going to be adding into this this data sheet The Source URL is where the URL is going to be coming from I have a single line text as as URL field type and the next one here is the date publish which I have it set as to include the time in include the time in the time zone I also have it set where this information when I created this record automatically and then the content would be a a long uh text pH type which will include the article itself so you can see here when we examine one of these records you can see here that this is a pretty short one if you go some of these articles you can hear that some of these articles are pretty lengthy and it has all the different details including the article in addition we're also going to be including the emailed column so you can see here that the field type is a check boox which could only be a one or a zero yes or no type of response I see here I can change the icon as well if I want want to so this will be displayed when you check on this field so this is the makeup for the a table data sheet that we're going to be working against with so let's go ahead and add a new agent here within this AI table folder let's go ahead and do and click on this plus sign where we can add a new AA agent here so let's go ahead and add a new a agent you see here that I have a new AA agent too which I can rename it to something else you see here that we're going to be prompted to use either the QA in the chat so you can see here that I can choose either one of those so we're going to go with a Q&A since we're going to be uh using our content to train this uh a agent so we're going to go and click that click next on that one and the next next step that we're going to be uh doing is we're going to be CH selecting the data sheet so we're going to go ahead and drill down to the YouTube demos and inside of AI table there's say AI news data sheet and then from here you can select from a particular view that you want so here I'm just select the default one which doesn't have any uh uh filtering inside of it so let's go ahead and click okay and from here uh this is probably going to take uh a minute or two depending on how many records you have in this uh data sheet in my case I think I do have about 49 records that or 56 records that I'm working with so it can take a little bit of time depending on on really how much you have so in our case only take like a few seconds since I only have about 56 records in it so when you first get started on building your AI agent you can see here that once it's been trained on the content for us you can see here that there's a few questions that is that's ready to go that is based on the content that the agent has been trained on in this case how much funding did hi had raise in recent funding round so you can click on one of those questions and the agent is going to respond accordingly specific to that so you can see here that there's an additional questions that you can also ask so it's giving you some hints as to what type of questions you can ask based on your content that you provided when you ask a questions uh within this AA agent of Q&A you just have to make sure that the question uh that you're asking is tailored to whatever content you're asking otherwise the agent is not going to have an idea of how to respond to your question so for instance if I ask it about certain news what is the latest AI news use just to kind of keep it generic so the agent could respond to that question just depending on how much content do you have and how much data it can work with so in this case it was able to pull something based out of the generic uh question so the latest AI news includes information about crypto mining pivoting to private infrastructure for AI companies China's homegrown AI models expanding and Google experts warning about AI distorting distorting reality so you can see here that it's pulling all that information based on uh the specific data that I have here uh whatever data is been trained on within my content here you see here that I I can ask questions regarding you see here that it's pulling based on the crypto miners you can also have some questions regarding the different things that you have here so that's for the AI agent aspect of this so they also have an API where you can access and interact with your agent via an SDK or an API so you can see here that they have one for python JavaScript and obviously curl where you can do an API integration and do a post request using this URL so this AI agent is the ID specific to this AI agent and then this completion and this gives you a return data example here that you're going to be expecting when you when you make a request to that endpoint you can see that the data that is been uh sent back uh when making the request is in accordance to the o openi specs you can see here that the choices um have a message and then he has the content and you can see here it also as well you can also see that uh there's also some usage information such as what how many tokens was used and the completion tokens they were used and then you can see here that the total tokens that were used to create this response was 21 just for an example here but you can see here that you can use the API or you can interact with the AI agent in various ways using the API or you can use the SC2 to speed up that process so let's go ahead and jump into um active pieces since we've already set up the uh a table data sheet here let's go ahead and jump into active pieces so we're going to be using Google news as the news source for this RSS feed that we're going to be automating so to keep things simple instead of having to pay for another RSS feed aggregator such as RSS that app which you can also use if you want to do a subscription it's not that expensive but we can use this for all kinds of different feeds that you want you can use this for YouTube and you can combine multiple feeds into one and you can do some automation on top of that which is great so instead of using that we're going to be using Google news and we're going to be using the RSS feed for Google News the main thing that we want to do here is we want to grab the RSS feed for Google news and that's what we're going to be using to do automation with that's what we're going to be using to trigger our automation every time that we get a new news added to our RSS feed we're going to be doing some automation on top of that and grab the content how we going to do that with Google News you can see here there's really no straightforward way of getting the RSS feed for Google News obviously we can do a simple Google and that's how we can grab the RSS feed you can see there's really no option for RSS feed so the best way to get the RSS feed for any news feed for any website that you have in mind is to get an extension so the extension that I recommend is get RSS feed URL which you can get from the Google Chrome Store which you can install you see I have it installed I also have it painted as part of my toolbar so you can have access to it whenever I need it I can go back to Google news here and once I type in for instance a subject such as artificial intelligence I can go ahead and click on that RSS extension and it will just give me the RSS feed URL which I can then go ahead and copy so I can go ahead and paste that into a separate tab which you can see here it gives me the actual RSS feed URL which I can work with inside of active pieces so now I have that URL copied let's go ahead and take a look at some of the possible articles that we're going to be scraping as far this automation so you can see here some of the articles that we're going to be possibly going to be scraping is inside of this pay wall you see here that to access this article from New York Times I basically need to create an account or I have to get a subscription in order for me to read this article so that's one example another hurdle that we're going to be encountering is each website has its own layout for instance this one has this ads right here as a lot of websites have this uh list of articles on the right hand side and also the menus so there's really no cookie cutter approach as to how to web scrape content from different sources especially different websites so especially articles such as article as this where it's behind a pay well so having to scrape this article is a little bit more complex just to keep our life simple we're going to be using fire here which turns a we website into llm llm ready data so we can easily web scrape the content of any website that we can imagine including the New York Times article here and we can use fire C for that just have just for an example you see here the article that we're just looking at for the the New York Times you can see here that the investors pour 27.1 billion into AI startups so you can see here just looking at from here behind the pay wall you see here that there's really no other information that you can grab from article we didn't except for these two things right here which is the title of the article and then the little description here underneath that so if you can see here firec was able to grab all this information I'm going to read it briefly and just kind of give you an idea and sense of what this tool is capable of you here the title of the article and then also the little description you he that it was able to scrape some other information as well and then there's some information regarding some startups for two years many unprofitable Tech startups have cut cost and sold themselves out of business so there some reference here regarding this article and now the AI boom that started in day 2022 has become the the strongest Counterpoint to the broader startup called downturn so it was able to extract more content than what's available for us which is great so which is why we're going to be using faral for this we're able to do a web scroll for an entire website using using a single web Source right here here you can just pass in a single website it will scrape and go through all the different links within that website and it will give you a result in this array type of format where it'll give you the URL and all the different pages within the URL that you've given it and it's going to give you all the different contents that's available within that page so you can capture you know the website as a whole or you can capture it on a per page basis and you have some samples here as well how to use it inside of python node or curl if you want to integrate your app within fire craw you can use Curl or you can use via manual integration via an API or you can use python or NOS using their SDK so which I'm going to be showing you guys in a little bit how to use uh we're not going to be using the STK per se but I'm going to be showing you guys how to set this up using an using axios so let's go ahead and jump into active pieces and let's go ahead and set this up all right let's go ahead and start off this automation by adding this uh RSS feed trigger going to go ahead and paste the URL that we generated from the previous uh step when we received or when we generated the RSS feed URL using the extension let's go ahead and paste that here and it's going to be a new feed new item in feed uh trigger in RSS feed so once you have that URL in place let's go ahead and load the data so we have some sample data to work with so let's go ahead and check this out so you see here there's there's a link right here where it's not really the link to the actual article but instead this is a Google News redirect URL so let's go ahead and examine this one we see that it goes to this page which contain this information right here which contains the URL and then it goes to the actual article website so that's what we're going to do is the next step is we're going to be grabbing the actual URL to that website since that's not really the actual URL that we want so the first thing we're going to be doing is we're going to be adding a code piece here we're going to be adding a code by adding U code piece right here and then we're going to be passing in the URL and that's a value and we're going to be sending it to the the link that we receed from the RSS feed and then we're going to be going into the code and then we're going to go ahead and expand this one there's two packages that we need to install in as part of this code the first one is going to be the Cheerio where which we're going to be using to par out and uh get the content within the uh the redirect body the HTML uh which we're going to be grabbing from the uh redirect website that Google news has given us so we're going to go and uh retrieve the content from that redirect body and then we're going to price it out using cherio uh and in order to reach out to that website we're going to be using a package called axios which we're going to be using to make an HTV request for that URL all right so two libraries so the next step is we're going to be dealing with the code inside the code is we're going to be in addition to the code that's been you know set for us by default when we add add a code piece we're going to be adding two lines here at the top which we're going to be uh declaring to add a reference to axios which we're going to be referencing the axis object within the axis library and then we're also going to be referencing the Cheerio from within Cheerio Library I'm going to declare a couple of functions here which I'm going to be going through more in details let's go ahead and paste that here in the bottom and I'm going to add a couple things on the top so the first thing we're going to do here so when we first execute this code it's going to go through and run this code function which we're then going to be structuring the URL from inputs so remember that we pass in the URL as part of this code so that's going to be the actual redirect URL from Google we're going to just pull it in and assign it to URL here so once we have the URL let's go ahead and grab the redirect body we're going to be using this get from text URL which takes in a URL which we're going to be using axios to do a request and get the body from that redirect website so once we have loaded up the response we're just going to pass in and assign the HTML of that response into an HTML variable here once we have the HTML available to us we're going to go ahead and use cheero and assign and just load up the HTML that we receed and just going to assign it to a dollar sign here constant so once we got the HTML and we're able to load it up inside of Cheerio the next line line 19 is where we extract the body of the text and then we're going to be setting it inside of this text body using this text function right so we're just going to grab everything all the different contents and texts within a body element and then we're just going to set it right here as a text body and then we're just going to return a text body as part of this function uh we also wrapped this function inside a tri catch just in case there's an error that occurs and we can capture that with the Consol error and then retro that exception so once we got the get text from this URL we're going to go ahead and and set it inside of this constant called redirect body which then contains the actual HTML for the redirect body that we receive so next part of the code is to actually get the URL So within the body that we extracted from the previous lines from the redirect body so now that we actually got the HTML content of the actual redirect page we can then go ahead and extract the actual URL for that website that we're trying to do a web scraping for so let's go ahead and look into this function right here so this one accepts a string of input which we're then going to be assigning to this actual URL so we're going to be calling this function and we're doing an await on it since it's an async function so let's go ahead and take a look at what's inside of this so inside of this get URL up to word we've declared a Rex here where we're going to be doing a match on the string that we've received from the previous step and we're just going to match uh and find for anything that starts with an HTTP or https and ends when with a window that whiz so while I was doing some research and trying to extract information out of the redirect body I was able to figure out a more consistent way of grabbing the the URL from the body and I was able to extract it via a Rex so we're doing a match here on the input and we're try trying to match it and see if you can find anything that matches within the certain boundaries right so if it matches and the matches is length is greater than zero then there's a match that means we're going to be returning the first result that we found and we're we're going to be replacing the window that wi with an empty string so it's going to be either an HTTP or an https as the website could be in a nonse secured URL or secured URL so we want to be able to grab and pull any of those type of we websites and then anything that ends with window. Wiz so we're going to be returning that if it matches otherwise it's going to be in all and we're setting it as part of this actual URL here and then from here I can just return this actual URL if I want to and then let's go ahead and format this document and do a test so this could take you know a few seconds as the axus will have to reach out and do an HTTP request on the redirect and then we have to scrape it and then now we get the actual URL here and see here that this is the actual URL which should match the URL that we end up going to after the the redirect happens so let's go back to active pieces let's go back and return this one and this is going to be we're going to be calling this get yourl so this is going to be the main responsibility of this code is to just get the UR from the redirect body and then we can use it for any subsequent parts of this automation so next thing that we want to do is we want to do a a web scraping using firec so we're going to go ahead and declare a new code here which we're going to be using code again mentioned like I previously mentioned the fire has some SDK which I tried using but had some issues when using it inside of the code here so we're going to go ahead and just use uh just manual way of doing some integration which we're going to be using AOS again and run some code and then make the HTTP request to fire call Api so let's go ahead and do that all right so since we're using fire call and it requires an API key so I went ahead and added a get fire call Key here uh which I'm pulling it from a storage within across different projects so I stored the faral key API ahead of time and then I'm doing a get here so I'm not going to be showing uh you the step here but essentially I'm I just did an insert or put on this K and then I'm pulling that key inside my code so I can pass it it right here I can go ahead and pass in my key right here here which I'm going to go ahead and see if I can hide it fire call Key and then I'm going to be pulling it from my storage which hopefully it's invisible enough so let's go ahead and another thing that we're going also going to be passing it here it's going to be the the URL that we want to do a web scraping on which is the result from the previous step which is actually getting the URL so let's go ahead and go back to that step and do a test here so now that we we got the actual URL let's go ahead and pass it in as part of a parameter for this code and let's go ahead and get the URL the result so now that I have the firec key and then the the URL as part of this parameter let's go ahead and expand make this full screen okay so for this particular code I'm going to be using axos again to make the HTTP request to the farc API so let's go ahead and add the package for axios and let's go back again to the code so first thing we'll be doing here is going to do an import axio from axio right so we're going to be pulling out that object so then we can use that object within this code and then we're going to be structuring the actual the URL and the fire c key which I previously mentioned I defined here just make sure that the spelling of your inputs matches whatever how you they structure it in your code to match right here and then I'm just declaring it as a constant within right within the code the second thing that we're going to be declaring is the actual function to do the web scrip scraping for so I'm going to go ahead and copy some code here below it so this is going to be the web scraping URL which I'm going to be doing in a way here so I'm going to replace the return true and I'm going to be returning the result of that scrape URL so two things that we're going to be passing in as part of this function is it accepts a URL and the key for fire CW so let's go ahead and break this code down let's go and do a format so I'm doing a return of anything that I received back from this function when I call this function so I'm doing an await for this function and passing the URL and the farc key I'm setting up an options right here for axos which is which contains a a method of post and then specifically I'm using this URL to do a web scraping for and then I'm I'm essentially I'm passing in uh the key as part of the header so I'm doing authorization authorization Bearer and then I'm passing in the key as part of the headers and then I'm using a content type of application for/ Json as that's the type of content type that we're expecting to receive and then in addition to this we're also passing in the the data that contains an object of URL which we're passing in right here so if you want to uh pass in uh the entire website then we have to uh construct it in a way where we will receive an array of URL and contents since we're only scraping for a single URL uh this is how we create objects to make the request for this particular endpoint so this is how you construct the data and it's going to have an object of URL right within this we're going to be wrapping the actual execution of the actus to do a post method inside if a TR catch just in case something happens in which case if there's an error we're just going to return an empty string if not then we're just going to go ahead and just capture the response and the response is always going to be inside of the data so the data with an axos always lives in this do data in this property we're just going to go ahead and return that so let's go ahead and let's go ahead and format this real quick and let's go out and let's go ahead and test this step see if it's working all right so took a few seconds but we got the records that we need like in their documentation I've stated you're going to get this access to true and then you're also going to get the data with the content or a markdown so whatever type of data you you prefer to work with either the actual content or the markdown I think it's very similar anyways it doesn't really matter in our case but it also includes a title and some of the metadata information such as description for that particular web page so it also includes the return code 200 and some other meta information such as the URL and so forth so now we have the actual uh content that we can work with so we can call this web scrape URL with firra just to be more specific as to what we're doing in this code since we're doing multiple codes here all right so the next thing we're going to be doing is we're going to make determining whether the the result that we get back from from fire call is successful or not so we're going to do a simple check here we're going to do add a branch and we're just going to determine whether that the result that we get is true all right so we're going to do a Boolean is true and if it's true then we can go ahead and proceed with doing additional testing do we have any content essentially it is right so we have any content and then if it's true then we're going to go ahead and proceed with the automation so the next thing we're going to be doing is we're going to be extracting some information within the article or within the content since it's not a perfect article or summary content we're just going to go ahead and use AI to even refine the content that we received back from fir craw and before we insert it inside of a table so let's go ahead and add a second AR step here or step after we've determined that there's a content by adding stco so we're going to go ahead and use stco here and then I'm going to be using ask Ai and then using my ster connection and this time we're going to be using I think 4 uh GPD 4 might be good for this one I'm just going to go ahead and copy a prompt okay so here's the prompt that I have here and we have to make sure that the SC web script data is coming from a fire C here so let go ahead and insert within the double code I'm going to go ahead and insert the data that we receive I'm just going to use and use the uh the content here so I have the prompt right here where it says act as a data extraction specialist your task is to parse article content from web scrape data the goal is to provide only the relevant article content while ex excluding any unless information such as ads navigation bars sidebars so we're just going to grab just the main content information so sometimes fire call or any of the web scraping tools that you use they tend to also include some information that not really relevant to the article such as the banner information such as the ads such as the link information so want to make sure that we get rid of all those information and we're adding a prompt here to just essentially just extract the key information that we need just for that article so in this case we want only want to extract the article and then we're passing in the v variables which we are setting the context for which is going to be the result that we get back from fire call data right so we're going to go ahead and execute this so what it does is essentially the AI is just going to clean this up and just going to remove anything that's isn't really pertain to the article so let's go ahead and expand this one so you can kind of see the content have an idea so there's some line breaks in between there's some articles so this is perfect and I'm just going to rename this to extract details from the article ccle cuz essentially that's what it is so the last step that we're going to be doing here is we're going to be inserting the records inside of a table all right so we're going to be uh grabbing a table here and then we're going to be creating a record inside a table and then using that connection and the space we're going to be using the same a new data sheet that we we've been using in this tutorial and then we're going to be passing in the title so the title can come in from the actual RSS feed which is the VT Professor using computer and then the source Source URL would be the actual URL that we' extracted when when we recode the redirect website for Google so we're go ahead and extract get the real URL and not the redirect URL and the date publish is going to be automatically added for us inside a table since we've automatically set that to automatically be added when we creating a new record and then lastly here we're going to be adding the content which is the result that we get from a table so let's go ahead and test this step and let's go back to a table you see here at the bottom we added the 57th record here you see here the title it's got to expand this one you see everything so it has here the title it has the URL and he has the date publish which is the current date and the time and also the content right so has this Virginia Tech professors using computer games a common hobby for many across the United States to enhance uh cyber security and artif artificial intelligence you see that you can kind of go through this article right you see the details of this article and including the actual formatting the line breaks in between and you can go back to the article so which is pretty lengthy it kind of gives us a little bit of summary you can now use this to do if you're repurposing this content for a newsletter or or whatever you're trying to keep up with a news stuff or whatever news articles that you're trying to keep up with this could be something that's handy for you so that's that for this video so if you're new to the channel and you haven't subscribed yet please go ahead and hit subscribe if you like this type of content like always hit like on this video and if there's any tutorial that You' like me to do in the future please go ahead and leave it in the comments I read every single uh one of your comments so please go ahead and drop a like and I'll see you guys on the next video bye

Channel: CodingMenace

Views: 936

Keywords: automation, coding, software development, tools, software, ai tools, ai automation, activepieces, aitable, aitable ai, zapier, make, automation services

Id: fuuhsiR-Doc

Length: 78min 53sec (4733 seconds)

Published: Tue Jul 09 2024