Applies to

Smartsheet
  • Pro
  • Business
  • Enterprise

Create New Sheets from Google Drive

PLANS

  • Smartsheet
  • Pro
  • Business
  • Enterprise

There are a few Smartsheet-Google Drive integration points available to install from the Chrome Web Store:

  1. Smartsheet Merge: Strategically import Smartsheet data into your Google Document.
  2. 内容同步: Store responses to Google Forms in a new sheet in Smartsheet.
  3. Create new sheets from Google Drive: New sheets will be stored in Smartsheet, but a link will also be created in Drive so you can easily open them from there.

NOTE: You must use the Chrome browser to install any Smartsheet app or add-on initially but after the install, you’ll be able to access the Google Drive-Smartsheet features in any browser.

In addition, there are several integration points with Google that don't require any installation. See a full listhere.


Create New Sheets from Google Drive

This integration point enables you to create new sheets in Smartsheet from within Google Drive.

NOTE: If, at any time, you see an error that you can't use the integration as your domain has disabled third-party apps, this can be resolved by your Google domain admin usingthese instructions on Google's support site. Reach out to the admin of your Google account and ask if they'd be willing to change the settings and allow use of third-party apps such as ours.

  1. To get started, install the app from theChrome Web Store. If you're a Google Apps user, you can also install a fuller integration from the去ogle Apps Marketplacethat will include this functionality.
  2. Login to your Google Drive account
  3. Click on theCreatebutton in Google Drive, then selectMore>Smartsheet.
  4. Name your sheet and choose whether to start with a project sheet, task list, or blank sheet. A link to the new Smartsheet will be created in Google Drive.
  5. You can also open any Google Spreadsheet, Microsoft Project (.mpp), Microsoft Excel (.xls, .xlsx) or CSV file as a new sheet in Smartsheet by right-clicking on the file in Google Drive, selectingOpen Withand then selectingSmartsheet. The file will be imported into Smartsheet creating a new sheet and a link to it will be saved in Google Drive.

The links in Google Drive will launch the sheet within the Smartsheet application. The links can be moved into any of your Google Drive folders, including those that are shared with others. However, team members will need to beshared to the sheetin Smartsheet in order to open the link from Google.

NOTE: Currently there isn't a method to create links for existing sheets.


Uninstall Apps and Add-ons

Use the instructions on Google's Support site foruninstalling apps from Google Drive.

Was this article helpful?
Yes No