Icon

How to Sync Accruals and Chart of Accounts Between Glide and Google Sheets

Learn the step-by-step process to sync approval data from Google Sheets to Glide and sync the chart of accounts from Glide to Google Sheets.

By Kaustubh

In this guide, we'll learn how to sync approval data from an approval sheet to Glide and sync the chart of accounts from Glide to Google Sheets. This process involves updating specific sheet IDs and app IDs in your script, as well as configuring actions within Glide. By following these steps, you can ensure that your data remains consistent and up-to-date across both platforms.

Let's get started

Moving on to the third script, two things are happening. First, we are syncing the approval from the approval sheet to Glide. Second, we are syncing the chart of accounts from Glide to the Google Sheets account. The process is similar to how you would handle bank realization.

2
Click on "Viable Add Ro"
Step #2: Click on "Viable Add Ro"

Almost all the steps are similar to copying the BR and the steps that are different are mentioned below.

First, you need to make a change for approval. Add the new sheet ID on line 32. Then, change the app ID on line 57.

4
Change the sheet id on line 32 with the copy of the accrual sheet that you made.
Step #4: Change the sheet id on line 32 with the copy of the accrual sheet that you made.

The rest of the steps are the same. One more thing you need to do is use the sheet we created, which is a copy of the "Modernizing Processes" sheet. Remember that.

5
Paste that sheet id on line number 88 inside the double inverted comma
Step #5: Paste that sheet id on line number 88 inside the double inverted comma

Paste the new sheet ID for that sheet here.

I hope that is clear. Next, go into Glide and open the approval tab.

7
Open Glide
Step #7: Open Glide

You have sync data here. Click on the button, then click on the action. Next, click on edit action. Paste the new deployed URL that you get here.

8
Click on "Button"
Step #8: Click on "Button"
9
Click on Action
Step #9: Click on Action
10
Click on edit action
Step #10: Click on edit action
11
Click on Trigger webhook
Step #11: Click on Trigger webhook
12
Paste the new URL that you got after deploying
Step #12: Paste the new URL that you got after deploying
13
Click on close
Step #13: Click on close

Close the window, then go to the admin panel.

In the admin panel, go to Chart of Accounts and then Projects.

Go to the last button, which is "Sync Chart of Accounts." Click on "Edit Action." In the webhook section, change the URL.

Add the new URL that you pasted in sync data for approval.

14
Click on last "Button Block"
Step #14: Click on last "Button Block"
15
Click on the "Sync Charts of Accounts" Action
Step #15: Click on the "Sync Charts of Accounts" Action

You paste the same URL here.

16
Click on edit action
Step #16: Click on edit action

I hope that is clear.

17
Click on Trigger Webhook
Step #17: Click on Trigger Webhook
18
Paste the same URL here
Step #18: Paste the same URL here
19
Click on close
Step #19: Click on close

And all is done for copying the accrual

How to Sync Accruals and Chart of Accounts Between Glide and Google Sheets