Speckle with Google Sheets

Features & Ideas
7

Hey @eugene thanks for checking in on this!

We haven’t created a connector for Google Sheets yet and for the time being it’s not on our roadmap - our focus is reaching feature parity with v1.

But the good news is that sending and receiving data is super easy with our new v2 API.
See example AppScript functions to create a stream or get the current user:

function createStream() {
  let  url ="https://staging.speckle.dev/graphql"
  let graphql = JSON.stringify({
      query: `mutation streamCreate($myStream: StreamCreateInput!) { streamCreate(stream: $myStream) }`,
      variables: { 
        "myStream": {
            "name": "Sample Stream",
            "description": "Created from Google Sheets!"
          } 
      }
    })
  let params = {
    method: 'POST', 
    payload: graphql,
    headers: { 
      'Content-Type': 'application/json',
      'Authorization': 'Bearer PERSONAL_TOKEN_HERE'
      }
   }
  var response = UrlFetchApp.fetch(url,params)

  Logger.log(response);
}


function getMe() {
  let  url ="https://staging.speckle.dev/graphql"
  let graphql = JSON.stringify({
    query: `query User {
                      user{
                        id,
                        email,
                        name
                      }
                    }`,
      variables: null
    })
  let params = {
    method: 'POST', 
    payload: graphql,
    headers: { 
      'Content-Type': 'application/json',
      'Authorization': 'Bearer PERSONAL_TOKEN_HERE'
      }
    }
  var response = UrlFetchApp.fetch(url,params)

  Logger.log(response);
}
1 Like