Icon

How to Sync Bank Realised from Google Sheets to Glide

Learn how to sync bank data from Google Sheets into Glide with this step-by-step guide. Follow the instructions to ensure seamless data integration.

By Kaustubh

In this guide, we'll learn how to sync bank data from Google Sheets into Glide using Google Apps Script. This process involves creating a new script project, copying and pasting code, and making necessary adjustments to ensure smooth data synchronization. By following these steps, you can automate the data transfer and keep your Glide app updated with the latest bank information.

Let's open the 2nd script here and

2
Open link in cell A3
Step #2: Open link in cell A3

First, open a new tab and type "script.google.com"

Go to google.com and click on "New Project." Name the project "Client Br GlideSync." After renaming the project, go back to the "All Webbooks" sheet. Open the link in cell A3, copy the sheet, and paste the code into the new project you created. Click "Save." Next, open the BR sheet using the link in cell D3 and make a copy of that sheet.

4
Click on "project"
Step #4: Click on "project"
5
Click on "Untitled project"
Step #5: Click on "Untitled project"

If you have already made a copy, you can use that. I would again mention the client name BR and GlideSync, so you don't forget.

6
Type "Client - BR Glide sync"
7
Click on "- BR Glide sync"
Step #7: Click on "- BR Glide sync"

You can have a folder dedicated to each client and save the respective sheets in the client's folder.

9
Click on "➡ Viable Add Rows - BR v2 ("
Step #9: Click on "➡ Viable Add Rows - BR v2 ("
11
Click on "new Date ("
Step #11: Click on "new Date ("
12
Type "Ctrl + A"
13
Type "Ctrl + C"
14
Type "Ctrl + C"

Now that I have done that, the next step is to make a copy of the modernizing processes sheet, as I mentioned in the previous guide about syncing.

16
Click here
Step #16: Click here
17
Type "Ctrl + A"
18
Type "Ctrl + V"
19
Click on "← ¢ a"
Step #19: Click on "← ¢ a"

Since you have already done that, please look at line number 22. I have written a comment: "new BR sheet link."

21
Click on "BR"
Step #21: Click on "BR"
23
Click on "File"
Step #23: Click on "File"
24
Click on "File"
Step #24: Click on "File"
25
Click on "a copy"
Step #25: Click on "a copy"
26
Click here
Step #26: Click here
27
Click on "Copy of BR"
Step #27: Click on "Copy of BR"
28
Type "DeleteDeleteClient - "
29
Click here
Step #29: Click here

Please copy the ID that appears after the "D" and backslash from the BR sheet.

30
Click on "Make a copy"
Step #30: Click on "Make a copy"
31
Type " Glidesync"

Copy that and paste it into the new script, then hit save. Next, in the first tutorial, I asked you to make a copy of the app. Go into the new version of the app, the copy you already made. Navigate to data, open the bank realized table, click on show API, and copy the secret token.

33
Click here
Step #33: Click here

You can copy the app ID from here. You see in the constant, there is an app colon app ID. Copy the app ID and paste it on line 48. I have left a comment here as well.

34
Click here
Step #34: Click here
35
Click here
Step #35: Click here

You don't need to change anything else in the code. Save the code, then click on deploy. You will need to do a new deployment.

37
Click on "("
Step #37: Click on "("
38
Click on "("
Step #38: Click on "("
39
Type "Ctrl + V"

Click on the settings icon. Select "Web App" for users accessing the web app. For anyone with a Google account, you'll need to change the access settings.

40
Click on "+ ← ¢ a"
Step #40: Click on "+ ← ¢ a"
41
Go to Glide

open the copy of the app that you created after first tutorial

42
Open the copy of the app that you have created
Step #42: Open the copy of the app that you have created

Then, when you deploy, it will ask for several authorizations. You will need to authorize everything.

43
Click on Data
Step #43: Click on Data

Copy the URL, then return to Glide.

44
Click on "Bank Realised"
Step #44: Click on "Bank Realised"
45
Click on Show API
Step #45: Click on Show API

In the Bank Realized tab, you have the Sync Data option.

46
Copy the code after app: "<code>"
Step #46: Copy the code after app: "<code>"

Click on "Sync Data." Then, click on "Edit Action." You will see a webhook function. Paste the new URL you just created into the webhook field. Close the window. You are now done with syncing the bank realization portion.

47
Type "Ctrl + C"
49
Click on "Content - Type"
Step #49: Click on "Content - Type"
50
Click on "' Content - Type"
Step #50: Click on "' Content - Type"
51
Type "Ctrl + V"
52
Click on "application / json"
Step #52: Click on "application / json"
53
Type " //App Idnew "
54
Type "Ctrl + S"
55
Click on "var url = " https://api.glideapp.io/api/function/mutateTables ""
Step #55: Click on "var url = " https://api.glideapp.io/api/function/mutateTables ""
56
Click here
Step #56: Click here
57
Click on "+ ← ¢"
Step #57: Click on "+ ← ¢"
58
Click here
Step #58: Click here
59
Click here
Step #59: Click here
60
Click on "New deployment"
Step #60: Click on "New deployment"
61
Click here
Step #61: Click here
62
Click here
Step #62: Click here
63
Click on "User accessing the web app"
Step #63: Click on "User accessing the web app"
64
Click on "Only myself"
Step #64: Click on "Only myself"
65
Under who has access, change to "Anyone with Google account"
Step #65: Under who has access, change to "Anyone with Google account"
66
Click on Deploy
Step #66: Click on Deploy
67
Click here
Step #67: Click here
69
Click here
Step #69: Click here
70
Click here
Step #70: Click here
71
Click on Copy
Step #71: Click on Copy
73
Click here
Step #73: Click here
74
Click on "Button"
Step #74: Click on "Button"
75
Click on the action
Step #75: Click on the action
76
Click here on edit action
Step #76: Click here on edit action
77
Click on "Trigger webhook"
Step #77: Click on "Trigger webhook"
78
Click here
Step #78: Click here
79
Type "Ctrl + A"
80
Type "Ctrl + V"
81
Click here
Step #81: Click here

How to Sync Bank Realised from Google Sheets to Glide