Persistent Error: "The server might be busy or the file is broken."

DCuadra

I’m setting up a new connection to import a CSV file to a Google Sheet. My source is a Google Drive folder containing CSV files where I want to pull the latest file. When I enter this info the File Tab box gives the error “Error when loading the file tabs. The server might be busy or the file is broken. Please check the file or try again later.” The file in question is a 24kb CSV file with no additional formatting. I know Sheetgo can’t read certain file types but this is just a simple CSV table. How can I resolve this issue?

Karoline from Sheetgo

DCuadra Hi Dan,

This is indeed weird, I’ll reach out to my tech team and as soon as I hear from them I’ll let you know

Thanks

DCuadra

Update: The issue appears to have something to do with the format of the CSV itself. We’re converting to a new inventory system and I’ve used this workflow with the old system with no issue, but the new system formats the document header differently.

In my previous system the CSV had a title row followed by commas so the number of columns in the table were consistent.

In the new system, the CSV has 3 rows of titles with no trailing commas, making them not part of the table.

If I manually delete the first few rows, then Sheetgo recognizes the file again. However manually editing the CSV is not a viable option for automation. Is there any way around this?

Vitor from Sheetgo

Hello DCuadra instead of manually editing the file you could use the offset header option, you can read about it in this article, this feature tells Sheetgo to start reading the file after a certain row. Based on the screenshot that you shared you could set the offset to Row 5, like this it will skip the part that is no part of the table

DCuadra

Vitor from Sheetgo

I’ve tried this but I encountered 2 problems:

I can’t get through the setup screen to the Advanced Settings menu because it won’t let me proceed past the File Tab setting. I got around this by putting a properly formatted CSV in the folder while I did the setup, then swapping it out for the CSV I want to actually use before running the workflow.
When I set the offset row to 5, the content of the CSV pastes into my document as one column (i.e. including all the commas and not separated into separate cells).

DCuadra

Vitor from Sheetgo

Update: I set the starting row to 7 (the first row with the actual column headers) and it did import correctly with multiple columns!

Now a new issue has come up. I replaced the CSV in the folder and tried to run it again to verify, but Sheetgo no longer sees the files in that directory. I added a few files, but Sheetgo says the folder is empty so there’s nothing to import. I tried reauthenticating my Google Drive connection and clearing my browser cache but it still sees nothing. Any idea why it wouldn’t be able to update?

cteerakit

DCuadra I’m having the exact same problem. I can’t get through the setup screen. After trying the swap the file, it will get stuck at filtering step again as it can’t read the column of the new format.

Vitor from Sheetgo

DCuadra Great, part of the issue is solved, now about the files in the folder. I would advise you to try open the folder through the workflow view and redo the source step of the workflow. This might allow you to update the connection, give it a try and let me know if it works

DCuadra

Vitor from Sheetgo

I tried that. The folder shows no items in the Sheetgo workflow view but lists items in Google Drive when viewed through the web interface or the Drive for Desktop interface in Windows Explorer.

Vitor from Sheetgo

DCuadra that’s weird, I would advise you to schedule a support meeting with us, so that we can look at this issue together. I will send the link to schedule the meeting on your email

Karoline from Sheetgo

cteerakit Hi there, I sent you a message on the chat. ;)

bryanchan

Good Day,

I just encountered this error. There was no changes made to any file or process.

i even tried to create a new workflow, same problem persists it wont load the tabs

Need help please, been trying for 2 days now.

Thank you

Vitor from Sheetgo

Hello bryanchan let’s try a few steps:

1. Try to reauthorize the account, you can follow the steps in this article
2. If this doesn’t work could you share the workflow and file with me? I might need to take this issue for our tech team to investigate.

To share your workflow
Enter our web app, click on the workflow, and then on “share settings.” Add my email [vitor.m@sheetgo.com](mailto:vitor.m@sheetgo.com), press ↹ (tab key), and make sure you enable “manager access” and check the “enable file editing” checkbox

You will also need to manually share the source and destination files so we can investigate this.

bryanchan

Vitor from Sheetgo

I have done step 1 still no change. i have shared my workflow with you.

BryanTang

Vitor from Sheetgo

I have also encounter the same problem, i tried reauthorize the account and still doesnt work.

I have shared my workflow with you, are you able to take a look please?

bryanchan

Hello, just to give you an update, it has been almost 2 months since i reported this issue and no fixes have been made. if this is an issue alot of us are facing please let them know so they can fix the issue.