Collaborate on Google Drive Invoice for Personnel with Ease Using airSlate SignNow

Google drive invoice for Personnel

hi Welcome to our Channel in today's video tutorial you will learn how to parse all PDF invoices from Google Drive folder to Google Sheets using pdf.co and make we provide a link of the full tutorials in the description box below come and visit pdf.co for more info here's the sample Google drive folder containing several sample PDFs that we'll be working with for parsing all invoices in pdf.co so let's begin first log into your make account and click on the create a new scenario button next search and select the Google Drive app and choose the watch files in folder to trigger when a new file is created or modified in a selected folder let's configure your Google Drive configuration first connect your Google Drive account to make by following the prompts in the app in the watch file section select by created time as the trigger for the automation choose the drive where the folder you want to fetch is located select the folder you want to watch in your Google Drive account specify the file types you want to watch for enter the maximum number of results you want to work with during each execution cycle once you've done setting up the configuration run the scenario to fetch the folder containing the PDF invoices in your Google Drive account the scenario runs successfully and detects a new file to trigger the automation to parse the invoice using pdf.co and save the extracted data to a Google sheet in this step let's add the iterator tools to allow us to perform a set of commands repeatedly on a list of items under the flow control in the array section select the web content link from Google Drive now let's add other tools and select the set variable module to allow us to define a value once and use it multiple times throughout your build process which can make your files more concise and easier to maintain let's set up the variable tools first add the name of your variable next specify the variable's lifetime which is the period of time during which the variable will exist in memory then assign a value to the variable using an iterator or other appropriate method depending on your specific use case after completing the variable setup execute the scenario to observe the outcome once the scenario runs successfully add another module to parse data from the PDF invoices in this step let's add the pdf.co app to the workflow and choose the parsa document module to parse data from PDF invoices let's set up the pdf.co configuration first connect your pdf.co account to make by adding the API key you can obtain the API key in your pdf.co dashboard next let's select import a file from the URL option for the input file field then select the variable name containing the URL of the PDF invoices and add the template ID containing the parsed data you can create a template ID by visiting the link in the description box below once you've finished setting up the pdf.co configuration run the scenario to extract the parsed data value from the invoices pdf.co has processed our request and returned the parsed data value from the invoices let's proceed to save the parsed data value to Google Sheets in this step let's integrate the Google Sheets app into the workflow and select the add row option to add a new row to the Google sheet spreadsheet and map The Columns in the row with the corresponding parsed data values let's set up the Google Sheets configuration first connect your Google Sheets account to make next choose a path and method for accessing the spreadsheet then select my drive as the drive to use and enter the spreadsheet ID for the spreadsheet where you want to save the parsed data values specify the name of the worksheet indicate whether the table contains headers by selecting yes or no finally under the values field map the parsed data values from pdf.co to the appropriate columns in the worksheet once you have set up the Google Sheets configuration run the scenario to save the parsed data values to the Google sheet spreadsheet we successfully running the scenario and saving the parsed data values to the Google sheet spreadsheet to view the parsed data values open your Google Sheets app and navigate to the worksheet where you specified the data to be saved here are the parsed data values from invoices that were successfully saved to the Google sheet spreadsheet we have a lot of available tutorials that you can check on our pdf.co website you may also visit our YouTube channel and don't forget to hit the Subscribe button and click the notification Bell icon to stay updated with our latest videos thank you for watching