NOTION - New connector request

Features & Ideas
, , ,
1

Three days ago I have discovered something that I needed for many years but never knew what was called. Some call it the everything app, for others its like Excel on steroids.

For me I feel is going to be a way to organize and manage information both professionally and personally.

This is NOTION and I already set it up to make shopping lists, quantity and cost estimating which link to websites for the products and material providers.

But more than anything I think it can be like a centralized dashboard that connects me, the project and the client.

What I would like to have is a data connection between Speckle, Grasshopper/Archicad/Revit schedules and Notion tables/databases and even more.

Like i could send a screen snapshot, a text, comment or any other attributes!

I know you do have the Power BI connector which i need to explore someday but from what I see, Power BI is more focused on data visualization, reporting, and analysis, kind of a more corporate feel, while NOTION is more about general collaboration, project management and client presentations, perfect for small to medium size architectural projects and interior design projects.

1 Like
2

Hi @Constantinesis, thanks for your feedback. We also use Notion internally, it is a versatile and powerful tool for team collaboration. However, Notion connector is currently not on our roadmap as our focus is on improvements of the existing connectors. I’ll let you know if we get to Notion connector some time in the future.

In the meantime, use the import feature to bring your Excel and CSV files to Notion. Also, you can simply embed your Speckle models, more in tutorial below. I hope this helps you in collaboration with your project team and clients.

4 Likes
3

I have also connected Speckle comments to a Notion database in last year’s hackathon. It’s a hack, but it works. If you know Python🐍, you can take a look at the code and tailor it according to your needs.

3 Likes
4

Thanks! I`m not into Python or scripting in general but I will take a look when I have some time.
I did manage to adapt a Javascript code for Google Sheets to automatically import a tab delimited text file from Drive into Sheets :slight_smile:
Now if only Notion had had an in-house Google Sheets connector and better a synchronized one.

By the way, here is the code if you ever need it. You can change the tsvUrl with your own , but it has to be the direct download version, not the share-link version
I wanted this because Archicad exports TSV files for schedules instead of CSV :slight_smile:

function myFunction() {
  function importData()
  { var ss = SpreadsheetApp.getActive();
    var tsvUrl = 'https://drive.google.com/uc?export=download&id=103pFbN-Y02H_ydYsuBjxNhfqgjUSbwPQ';
    var tsvContent = UrlFetchApp.fetch(tsvUrl).getContentText();
    var tsvData = Utilities.parseCsv(tsvContent, '\t');
    var sheet = ss.getSheetByName('Sheet1')
      for (var i = 0; i < tsvData.length; i++) {
      sheet.getRange(i+1, 1, 1, tsvData[i].length).setValues(new Array(tsvData[i]));
    }
  }
  importData();
}
5

Hi there,

Could anyone provide guidance on how to resolve this issue?

Thanks,

TransportQueryError: {'message': 'Field "text" of type "SmartTextEditorValue!" must have a selection of subfields. Did you mean "text { ... }"?', 'locations': [{'line': 4, 'column': 7}], 'extensions': {'code': 'GRAPHQL_VALIDATION_FAILED'}}
Traceback:
File "C:\Users\Yohann Perrudin\AppData\Local\Programs\Python\Python311\Lib\site-packages\streamlit\scriptrunner\script_runner.py", line 475, in _run_script
    exec(code, module.__dict__)
File "C:\Users\Yohann Perrudin\speckle-hackathon-notion\main.py", line 475, in <module>
    comments = get_comments(stream=stream)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Yohann Perrudin\AppData\Local\Programs\Python\Python311\Lib\site-packages\streamlit\legacy_caching\caching.py", line 573, in wrapped_func
    return get_or_create_cached_value()
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Yohann Perrudin\AppData\Local\Programs\Python\Python311\Lib\site-packages\streamlit\legacy_caching\caching.py", line 557, in get_or_create_cached_value
    return_value = func(*args, **kwargs)
                   ^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Yohann Perrudin\speckle-hackathon-notion\main.py", line 210, in get_comments
    comments = client.execute_query(query=query)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Yohann Perrudin\AppData\Local\Programs\Python\Python311\Lib\site-packages\specklepy\api\client.py", line 160, in execute_query
    return self.httpclient.execute(query)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Yohann Perrudin\AppData\Local\Programs\Python\Python311\Lib\site-packages\gql\client.py", line 370, in execute
    return self.execute_sync(
           ^^^^^^^^^^^^^^^^^^
File "C:\Users\Yohann Perrudin\AppData\Local\Programs\Python\Python311\Lib\site-packages\gql\client.py", line 188, in execute_sync
    return session.execute(
           ^^^^^^^^^^^^^^^^
File "C:\Users\Yohann Perrudin\AppData\Local\Programs\Python\Python311\Lib\site-packages\gql\client.py", line 783, in execute
    raise TransportQueryError(
6

Hey @Yohann_Perrudin, s this using @gokermu code from 2022 or have you made edits?