Migrating to business plan

Ask for Help
1

Hi, I am currently subscribed to Legacy Pro and using Google Sheets as my database. My file storage is almost at its limit. My plan is to move a large portion of Glide image links to another Google Sheet and subscribe to a business plan to host the image storage. Is this possible?

2

Why do you have to move your image links to another Google Sheet? As I understand, subscribing to a business plan would increase your storage.

3

Here is my situation: I am using Google Sheets because the database was created by another developer involved in this project who used AppSheet, Adalo, and Google Sheets as reference data. The project involves managing complaints for gas stations nationwide. My job is to create an app for 400-500 gas station owners to lodge complaints and track maintenance progress using their business email. Glide was a viable option when I developed the app in November 2023 until bad news struck when Glide suddenly updated their pricing plan. I can’t afford to pay $6 per user per month for 400-500 users, and the number of users is steadily increasing. I only charge $2.5 per gas station owner per month, and I have a 3-year contract to deliver and maintain the system. I can’t ask the other developer to switch to Glide since many of their clients from various maintenance companies use AppSheet or other platforms.

The real sticking point right now is the file storage limit. I am in a dire situation if my complaint app fails to deliver the problem images sent by Glide. All other maintenance service companies will lose a clear understanding of any maintenance requests because images speak a thousand words.

4

One way to do it without extra plans you could write some app script which saves the images to your GDrive… then replace the image links with the GDrive ones.

5

I mean you said you are subscribing to a business plan here. But then you said.

So ultimately what you want is not a business plan, but something that can be used for 400-500 users and more? At that point, you would have to contact sales to see if Enterprise works for you.

6

It’s kind of hard to explain. The 500 users can only access work orders that are still open or pending. When a work order is completed, the other programmer will archive it in a separate database. I intend to keep the image storage intact for the maintenance team’s future reference. The business plan may not have any users, just a place to store images that have been uploaded before.

If there is another way to convert Glide images to Google Drive, it would be much appreciated

7

Is there any video tutorial for that? It would be much appreciated.

Thank you.

8

Start with this Apps Script. Tweak it in GPT for your use case.

function uploadImageToDrive(name,imageUrl) {
 
  var response = UrlFetchApp.fetch(imageUrl);
  var imageData = response.getBlob();

  var upFile = DriveApp.getFoldersByName('Glide images').next().createFile(imageData).setName(name);
  var id = upFile.getId();
  var url = "https://drive.google.com/uc?id="+id;

  return url
}

FYI storing images outside of Glide is not officially supported. If it’s only images and the images are normal size it should work in most situations.

2 Likes
9

ok thanks, I give it a try…