# 🤖 Importing data to Glide by use of robot (RPA) **URL:** \ **Category:** Community Resources\ **Created:** [July 12, 2021, 4:23pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008 "2021-07-12T16:23:22Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [July 12, 2021, 4:23pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/1 "2021-07-12T16:23:22Z")
**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** > > [Import Data From Excel & Sheets into Glide Table - #18 by Manu.n](https://community.glideapps.com/t/import-data-from-excel-sheets-into-glide-table/20184/18) I will show how to use a software robot (RPA) to do the job. **Challenge 2** Deleting items from Glide tables also causes problems as rows are not always deleted by Glide - they sometimes comes back. I propose that you just mark a row as deleted and then do a batch delete job by use of a robot **Video of setup** I will take you through the process in this video > **[Glide RPA copy delete.mp4](https://drive.google.com/file/d/1L88xGRHBWhhjVtMlO8mFJv3QDcf5d75x/view?usp=sharing)** > > Google Drive file. **How-to** Prerequisite: _Install the robot - it is opensource_ > **Installing robot** > > Install like suggested in root of c directory > > [Installation — TagUI 6.110.0 documentation](https://tagui.readthedocs.io/en/latest/setup.html#) > > If you want to further understand how to use the robot please have a look in the documentation > [Main concepts — TagUI 6.110.0 documentation](https://tagui.readthedocs.io/en/latest/main_concepts.html) _RPA script files_ Download the files and place them in this directory on your computer: C:\tagui\flows\samples > **RPA script for copying data from GS to GT** > > [Copy\_data\_from\_GS\_to\_GT\_ver\_1\_2\_template.tag - Google Drive](https://drive.google.com/file/d/1Ow2dxzTx7as7E97EwvqEsStCl3F4c-Fb/view?usp=sharing) > > > //----------------------------------------------------------- > > // Copy data from GS to GT > > // Created by krivo aka Kristian Voigt > > //----------------------------------------------------------- > > > > // this command that must be run in command line window (cmd) > > // tagui c:\tagui\flows\samples\Copy\_data\_from\_GS\_to\_GT\_ver\_1\_2\_template.tag > > > > //------------------------ open app and sign in-------------- > > //open the glide app > > > > //wait is used in order to make the app open correctly AND sign in. It can also be used to maximize the window > > wait 45 > > > > // ------------------------ copy --------------------- > > > > // Select the tab where list of elements are found to be copied > > click //button [contains(., ‘Copy to glide’)] > > > > // copy a number a elements from google sheet to glide table > > // sometimes the clicks are not registered so therefore you might have to specify a bigger number than elements that needs to be copied > > // the job will fail gracefully if there are no more items to copy > > for n from 1 to 100 > > click //\*[contains(@class,‘separator selected-item-list-item’)] > **RPA script for deleting data from to GT** > > [Delete\_data\_from\_GT\_ver\_1\_2\_template.tag - Google Drive](https://drive.google.com/file/d/16eLrkRdSGVSY-c-9CmBH1VHqexG5uL1z/view?usp=sharing) > > > //----------------------------------------------------------- > > // Delete data from Glide table > > // Created by krivo aka Kristian Voigt > > //----------------------------------------------------------- > > > > // the command that must be run in command line window (cmd) > > // tagui c:\tagui\flows\samples\Delete\_data\_from\_GT\_ver\_1\_2\_template.tag > > > > //------------------------ open app and sign in-------------- > > //open the glide app > > > > //wait is used in order to make the app open correctly AND sign in. It can also be used to maximize the window > > wait 60 > > > > //------------------------ delete ------------------------ > > > > // Select the window where list of elements are found to be deleted > > click //button [contains(., ‘Delete from glide’)] > > > > // delete a number a elements from glide table > > // sometimes the clicks are not registered so therefore you might have to specify a bigger number than elements that needs to be deleted > > // the job will fail gracefully if there are no more items to delete > > for n from 1 to 200 > > click //\*[contains(@class,‘separator selected-item-list-item’)] **App to try out** Copy the app to your own Glide account > **[Copy data from GS to GT](https://copydatafromgstogt.glideapp.io/)** **Run** Adjust the scripts so they point to your own app. Inside the script file it is indicated where to change Run the scripts from a command window (cmd in windows) **Use the concept in your already created app** There are a few ways where you can use the concept in your existing apps. 1. Recreate the sample app inside your existing app - you just need two extra tabs (which you should put visibility on so your users don’t see them) 2. Create a new app where the Glide table is a link to an existing table inside your existing app **Lessons learned** Trying to get the signing in process to be supported by the robot was a nightmare. Either the robot, cookies or glide made the email address reappear and couldn’t be totally cleared. Anyway, you will still need to input the pin-code so the benefit of automation a part of sign-in process isn’t that big. **Feedback** Please leave some feedback on how you succeed - or if you encounter problems e.g. when doing large Google sheets. ---
**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\ **Post date:** [July 12, 2021, 4:54pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/2 "2021-07-12T16:54:57Z")
Thin, I who put all my savings in the actions of mouse manufacturers !! With your robot, everything falls apart. Joke! ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [July 12, 2021, 5:00pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/3 "2021-07-12T17:00:10Z")
Any way via Mac OS ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 12, 2021, 5:08pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/4 "2021-07-12T17:08:23Z")
[https://tagui.readthedocs.io/en/latest/setup.html#macos-linux](https://tagui.readthedocs.io/en/latest/setup.html#macos-linux) yes, I expect so. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 12, 2021, 10:43pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/5 "2021-07-12T22:43:49Z")
This is so cool omg ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 21, 2021, 12:07am UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/6 "2021-07-21T00:07:07Z")
Just want to say thanks to you, I have been able to do this to import thousands of rows to Glide Tables in an app last week. I can let the robot do its thing while I do other tasks. I’m on Mac. Thanks a lot! ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [July 21, 2021, 4:35am UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/7 "2021-07-21T04:35:19Z")
@ThinhDinh cool. Great to hear ---
**Author:** ![elysium27](https://avatars.discourse-cdn.com/v4/letter/e/df788c/32.png) [@elysium27](https://community.glideapps.com/u/elysium27)\ **Post date:** [August 2, 2021, 2:48am UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/8 "2021-08-02T02:48:19Z")
Thanks a lot!! ---
**Author:** ![dvamvoo01](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@dvamvoo01](https://community.glideapps.com/u/dvamvoo01)\ **Post date:** [August 5, 2021, 10:22am UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/9 "2021-08-05T10:22:30Z")
Hi there, it might sound stupid but why would we want to transfer data from the google table to the glide table, isn’t it the same? what are the differences? Thank you in advance. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 5, 2021, 1:35pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/10 "2021-08-05T13:35:47Z")
With Glide Tables, you will enhance the performance of your app since data won’t have to travel back and forth between Glide servers and the Sheet. It also won’t cost you sheet edits. ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [August 5, 2021, 3:07pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/11 "2021-08-05T15:07:38Z")
@dvamvoo01 exactly as thinh says and sometimes you might also want to import data from a totally different source and here google sheets can serve as an intermediate source. Database → google sheets → glide table ---
**Author:** ![dvamvoo01](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@dvamvoo01](https://community.glideapps.com/u/dvamvoo01)\ **Post date:** [August 5, 2021, 4:47pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/12 "2021-08-05T16:47:36Z")
wooh i didn’t know about that and it is a perfect application for my app. thanks i will try to implement it ---
**Author:** ![dvamvoo01](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@dvamvoo01](https://community.glideapps.com/u/dvamvoo01)\ **Post date:** [August 5, 2021, 4:48pm UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/13 "2021-08-05T16:48:53Z")
Im amazed thank you for this integration! i will try to implement it… ---
**Author:** ![elysium27](https://avatars.discourse-cdn.com/v4/letter/e/df788c/32.png) [@elysium27](https://community.glideapps.com/u/elysium27)\ **Post date:** [October 13, 2021, 1:25am UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/14 "2021-10-13T01:25:33Z")
Building the data exclusively in Glide Tables is quite restrictive. I have a concern when data reaches 50k rows and above, I couldn’t archive it to my own database. My yearly data is about 50k and we know 50k rows cause huge performance issue in glideapps. So my plan is to archive it to external DB but I still couldn’t figure out the way to easily import it to my db. How do I export/sync data from glide tables to other sources? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 13, 2021, 2:02am UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/15 "2021-10-13T02:02:19Z")
This is a valid concern. 25k is already a big problem let alone 50k. I don’t have a good answer for now as you can’t mass import/sync data to Glide Tables in a matter of minutes, exporting however is possible with the export data option we already have. ---
**Author:** ![elysium27](https://avatars.discourse-cdn.com/v4/letter/e/df788c/32.png) [@elysium27](https://community.glideapps.com/u/elysium27)\ **Post date:** [October 13, 2021, 2:52am UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/16 "2021-10-13T02:52:40Z")
Oh sorry, yes we can export but we can’t do it in scheduled manner or to sync with external db right? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [October 13, 2021, 3:02am UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/17 "2021-10-13T03:02:34Z")
Yes, that’s true. ---
**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\ **Post date:** [October 13, 2021, 6:42am UTC](https://community.glideapps.com/t/importing-data-to-glide-by-use-of-robot-rpa/29008/18 "2021-10-13T06:42:54Z")
Computed columns are not exported, so not fully usable