go>> SmartSync-Sheet>> 返回
项目作者： Edenskull

项目描述 ：
Synchronization tool to sync smartsheet sheet to google sheet sheet
高级语言： JavaScript
项目地址: git://github.com/Edenskull/SmartSync-Sheet.git
创建时间： 2019-02-24T10:43:14Z
项目社区：https://github.com/Edenskull/SmartSync-Sheet
开源协议：MIT License
下载


SmartSync-Sheet

Image Banner




This script works with Google Appscript. This script is made for a use case like having to automate dynamic values in datastudio via a google sheet.

Getting Started

In appscript you can simply copy/past the code into your appscript ide.

Automate System

You’ll need to create a new trigger Go to edit > current project's trigger and here click on create a new trigger then you will be able to choose TimeDriven and set your setup of automatization.

Setup

You’ll need to adapt the project variables to your needs :

  • Change the variable smartSheetID with the smartsheet that you want to synchronize with. Right click on the smartsheet and then properties and copy sheet id.
  • Change the variable smartSheetToken with the token that you can generate in api access in smartsheet.
  • Change the variable sheet with the id of the google sheet that you want to synchronize with. (the id is in the url)

User Documentation

Coming Soon

Contributors

@Edenskull : Founder and project maintainer