Individuals, as well as companies, can use this free platform for Storage purposes. The workflow will now appear in the workflow dashboard where you can edit, delete or manually run the workflow.Google Drive is a free Cloud Storage Service provided by Google. If you want the workflow to be automatically triggered every hour, so that any new rows added in that duration are processed automatically, you can choose the option Run workflow every hour and then click on the Save button. Click Done to locally apply your changes.Ĭlick on Continue to proceed to the triggers screen. Preview and Save Ĭlick the Preview button and you should see a copy of the original file in your Google Drive created using data from the first row in the Google Sheet. You can also specify other email addresses to share the file with. You can also specify a dynamic sub-folder in the parent folder by using the curly braces notation.įor instance, if you specify / - to automatically share the copied file with the customer. The folder could be in your own Google Drive or a Shared Drive (Team Drive) folder. Next, choose the folder in Drive that you would like to copy the file to. Configure Google Drive Service Ĭhoose Copy File as the Drive Service and select the source PDF file in Drive that you would like to share with customers. Next, choose Google Drive from the list of available tasks. Inside the Conditions section, specify if you want your workflow to run only if the row data satisfies certain conditions. Click on Continue to move to the conditions page. Inside the Document Studio app, provide a descriptive name for your workflow and choose the specific worksheet in your Google Spreadsheet that contains the merge data. You may either open an existing Google Sheet or create a new sheet and add data in one or more rows of the sheet. Install the Document Studio add-on and open your Google Sheet to launch the add-on. The file exceeds 50 MB in size and thus cannot be shared over email so we'll make a copy of the file for each customer and share it with the customer. With Document Studio, you can create copy of a file in Google Drive and share with one or more users from new rows in Google Sheets.įor instance, here we have a Google Sheet containing customer records and we want to send a copy of the product brochure to each customer. Copy Files in Google Drive for New Rows in Google Sheets
0 kommentar(er)
