Scheduling posts with the help of a CSV file can support up to 500 posts at once. However, sometimes the CSV file can be a lot for certain servers or surpass certain rate limits for online clouds such as Google Drive, Dropbox, OneDrive, or even be taking some more time to load and be uplaoded. Let's take a look at both those cases below.

CSV file is taking a long time to get uploaded.

If your CSV file is taking some time to be uploaded and you are not getting a notification right away, then it is because the CSV file is still being processed.

Depending on the total number of CSV files that are being processed by Publer, the CSV file may take longer than usual for some cases.

In such cases, simply keep an eye on the notification bell on Publer so you know when the CSV is uploaded.

CSV does not upload properly due to Rate Limits from Drive/Dropbox:

Google does not like it when other services try to scrape and get data from their sites, in this case Google Drive.

They rate limit IPs so if you, or many users, try to upload media from Google Drive URLs at the same time, eventually Google will start throwing an error asking the IP (us) to "try it again later." Even though we use proxies, it's still impossible to bypass Google bots.

The safest solution is to use the official built-in Google Drive/Dropbox/OneDrive picker (but it can't be used together with the CSV functionality), rely on a different online storage platform, or use the Media Library on Publer which is guaranteed to work.

You can take a look here to see how to use the Media Library + CSV functionality:

CSV does not upload properly due to your Server:

Sometimes, certain servers cannot handle a lot of requests at one time -- say 500.

If that is the case, the only thing you could do is either upgrade your server, or you can use smaller CSV files.

Breaking them down to smaller CSV files, for example, turning a 500 row/post CSV file into 5 CSV files of 100 rows/posts.
Was this article helpful?
Thank you!