Any way to upload data to a Glide Table?

[ihackstuff]

Hi everyone! Thanks for all this help with all my questions.

Is there a way to upload data to a glide table? I’m trying to paste rows, and I can only seem to paste into an individual cell. I saw a thread from early 2020 that this might be an upcoming feature, so I’m not sure. Thanks!

[Jeff_Hager]

At the moment, there isn’t a good option to bulk import data, unless you want to get into since python coding.

Workaround for bulk importing data into Glide Tables (Python)

Hi all, Just in case this isn’t common, here’s a workaround I’m using to bulk import data into glide tables (need to use Python). Run the above script in Python and move to an open window with a glide table showing and your cursor in the first column you want to enter data into Once the script is done, data will be entered in automatically. [image] You’ll need to extend this to work with the data you want to enter. Cheers!

[Darren_Murphy]

I think this is the best workaround that I’ve seen so far…

Import Data From Excel & Sheets into Glide Table

Hello, Failing to have an import function. I used a fairly simple method to import 3 tables of around 400 rows each, it’s not ideal, but it’s better than editing everything. For simplicity You have a Sheet Source table and a Glide Destination table. Add a column to your Sheet Source “Copy ok” of type boolean. Create a List style tab with the Sheet Source as the source. And as filter “Copy ok is not 1” Then use a custom action ADD row, with as Sheet “Glide Destination” then mat…

PS. I had a look at that Python option. Whilst I haven’t tested it, as far as I can see it will only do a single row at a time. So unless I’m missing something, it’s basically just copy/paste row by row.

[Krivo]

Wonder if anyone has used robots (RPA) to copy data from google sheets to glide sheets? And whether there is a free RPA tool that can do so?

[slscustom.ru]

Hello, Krivo!
Yes, I used the free Microsoft Power Automate Desktop to press a pre-prepared button in the Glide application. The button triggered an action that copied from the single value column according to the row number, which I increased in the same action after adding the row. The robot waited for the number to change on the screen and pressed the button again. It seems about 2 seconds per row. I copied 322 rows in total. But sometimes the rows that were numbered for example 78 and 80 appeared in the copied table after the number 322.

[Krivo]

@slscustom.ru i have had success using a RPA tool as described in this post

Importing data to Glide by use of robot (RPA)

Challenge 1 In this moment of time it is not possible to import data (or paste chunks of data) into Glide. @Manu.n has shown a way to import a row at a time from Google sheets to Glide tables which is quite handy if you have not to much data to import. But if you have hundreds or thousands of rows this approach is not the way to go.

Manu.n's approach - great for a smaller number of rows

<a href="https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/…