Upload to Google Sheets

By combining the Export formula from the Export Tables Pro pack (or the Export Tables pack) with the UploadToGoogleDrive formula from the

Export to Google Workspace⁠

pack, you can upload your tables directly from Coda to Google Drive. This can be done in a button or an automation. For more information on the Export to Google Workplace pack, visit the

Export to Google Workspace Demo⁠

doc.

Parameters

Required Parameters

There are 2 required parameters for this formula:

account : The Google account you want to use (automatically populated by Coda once your account is connected)

fileUrl : The URL of the table you want to upload. It can either be the URL generated by the Export formula from the Export Tables Pro pack or an xlsx/csv attachment in Coda

Optional Parameters

There are 4 optional parameters for this formula:

driveFolderUrl : The URL of the Google Drive folder you want the Google Sheet to be created in (shared folders allowed). If omitted, they will go into your main drive folder

nameForUpload : Include this if you want to customize the name of your uploaded file. If omitted, your table name or original file name will be used

shareWith: Include this if you want to share the upload with any email addresses. This should be a list of emails to share with

permissionType : Use this to specify the permission type that emails defined in shareWith should have. The options are “Reader”, “Writer”, “Commenter”

Playground

fileUrl* : Export( tableName* :

Blank

⁠

, fileType* :

Blank

⁠

, includeImages :

⁠

, lastUpdated :

⁠

)

driveFolderUrl :

⁠

nameForUpload :

⁠

shareWith :

None

⁠

permissionType :

Blank

⁠

Upload to Google Sheets

⁠

Feedback

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.