Create row
Purpose of this building block
With this building block you can insert new rows into an existing worksheet.
1 variables
1 variables
${fileId}
${rowId}
Possible use cases
- Insert new lines into a timesheet
- Update a report with current values
- Example App: Purchase Order (Insert approved orders into sheet)
Configuration
Click on the bold text in the title of the building block to open the configuration dialog.
Edit
Click on the edit icon to edit the selected Google Sheet in a new browser tab or window.
Reload
Click on the reload icon to scan the sheet again to track down added or removed worksheets or columns.
When dragging this block into the flow you can either select an existing spreadsheet from Google Drive or you can create a new one. If you choose to select an existing sheet, a file picker dialog will help you to find the sheet on your Google Drive. Creating a new spreadsheet will open the new sheet in a new browser tab.
After selecting the Google Sheet a dialog will allows you to select the columns to be inserted when creating a new row and to specify the values for each column.
The columns of the new row can contain simple fixed strings or variables. As in most of the text boxes in Ultradox you can leverage the full feature set of Ultradox templating. This makes it easy to format dates, numbers, currencies etc. according to your needs.
Useful combinations
Import contacts
CONTACT GROUP
customer.name
customer.email
customer.id
customer.name
name
customer.email
email
customer.id
id
With the Load contact group building block you can load all customers of a Google contact group.
For each loaded contact a new row is inserted into a Contacts sheet using a Repeat building block.
name
Contacts sheet
email
id
File list
Google Drive folder
folder.filename
folder.filesize
folder.mimeType
folder.filename
filename
folder.filesize
filesize
folder.mimeType
mimeType
Instead of contacts you may also create a list of all files contained in a Google Drive folder. Using the List files building block you can load all files of a selected Drive folder.
For each loaded file a new row is inserted into a file using a Repeat building block.
As you may only want to list files but no subfolders you can activate skipping the Create row building block in case the listed item is a folder - skip condition: "${mimeType}"=="application/vnd.google-apps.folder".
filename
Filelist
filesize
Copy the List Files app to see this building block in action
Please note that in these examples rows were only added. Running those flows twice will add additional rows to your existing sheet. This is likely to result in duplicates. Consider clearing your sheet in a first step - see Delete row building block example.
Questions and Feedback
If you have any comments on this guide, feel free to add them right to the Google document that we are using to create this site.
If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.
Last Updated:
