Copy information from one sheet to another

[Mns_Glide]

hi,
I am working to move users from Googlesheet (GS) to Glide table (GT) to take advantage of the speed. I plan to copy user’s email from GS to GT and then do relations from there to take just the information I needed from GS.

I thought Add row might work, but could not find a way to do it. Kindly suggest other alternatives to complete this “simple” task.

Thank you.

[Darren_Murphy]

Maybe this?

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…

[Krivo]

If you need to move a substantial amount of data then you could consider getting help from a robot

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/…

[Mns_Glide]

Nice and simple for me to handle. Thanks

[Mns_Glide]

thanks @Krivo . My data still small so I will use Manu’s method.

[ichilddev]

HI hi @Darren_Murphy

How about duplicating the whole row in the Source Table Row to a destination Table via google sheet, when a certain value say Confirm is shown in Destination Table?

The source table and destination table are in 2 separate Apps, and only way to link both is to use google sheet. As such any changes in source table will be updating in destination table as well.

We are using Arrayformula + Importrange + Query in Google Sheet, to get the row. But so far, manage to get only one row as Query does not work in Arrayformula (for a range)

Any good idea or advise?

[Darren_Murphy]

Not exactly sure, but it sounds like you might be needing to use a filter formula.

@Eric_Penn might be a good one to advise on this, I know he does some pretty advanced filtering techniques on his projects.

[Eric_Penn]

@ichilddev

We are using Arrayformula + Importrange + Query in Google Sheet, to get the row. But so far, manage to get only one row as Query does not work in Arrayformula (for a range)

You should be able to combine Query with Importrange and return multiple rows. The syntax should look like…

=QUERY(IMPORTRANGE(“Spreadsheet_url”, “SourceTable!A2:F”), “Select * Where Col1=’Confirm’ “)

@ichilddev

How about duplicating the whole row in the Source Table Row to a destination Table via google sheet, when a certain value say Confirm is shown in Destination Table?

I’m a little confused how the confirmation process works. If I understand correctly I might use make/ zapier from the Destination table app to update a value in the source table. I’d create a new basic column in the Source table app and call it ‘Trigger’ then I’d write the value ‘Confirm’ to the Trigger column as needed.

Taking the example formula above we would return all rows that have the value ‘Confirm’ in the trigger column.

A tip with Importrange is always place your formula in row 2 and start your importrange from row 2 as well (ignoring the headers). Then use static headers in row 1 above your formula.

We do this because sometimes when importrange formula is recalculating the headers may disappear momentarily causing sync issues with Glide. Using static headers ignores this problem altogether.

[ichilddev]

Thanks for your reply…

Yes we use a trigger inserting the desired ID into the first column while a query in the second column shows the result

ARRAYFORMULA(IF(ISBLANK(A2:A)," “,QUERY(IMPORTRANGE(“XXXX!A4:AY”),“Select * where Col1 Matches “&ArrayFormula(”'”&textjoin(”.|“,1,”.“&filter(A2:A,A2:A<>”“))&”.*'")

Copy and paste the above from another site and i works!

Thanks for @Darren_Murphy @Eric_Penn your replies and effort!