Google Drive: loading an input feed and uploading an output feed#
Mergado can work with files on your Google Drive in two ways:
- Load an input feed directly from Drive. You do not need to publish the feed or Google Sheet at a public URL. The file stays private and Mergado accesses it through your Google connection.
- Upload the output feed to Drive. After every export, Mergado saves the output feed to the folder you choose. The file always has the same link on Drive, so you can keep sharing it or pulling from it.
You can use both options separately or together.
What you will need#
- A Google connection in Mergado Keychain. The same connection is used for Google Drive and Google Sheets — no separate connection is created. If you do not have one yet, you can create it directly from the wizard by clicking Connect Google Drive, or in advance in Keychain (see Mergado Keychain Connections Explained). The connection belongs to the online store, so in the classic wizard the Google Drive option is only offered when creating a project under an existing online store.
- A file or folder in your personal Drive or in a folder someone has shared with you. To load an input feed, you only need read access to the file; to upload an output feed, you need write access to the target folder.
⚠️ Shared drives are not supported yet. Do not confuse them with a shared folder. A shared folder is a regular folder on someone else’s Drive that they have shared with you — that works fine. A shared drive is a separate team drive in Google Workspace, which you can find in the left menu under Shared drives.
🔒 Mergado only sees what you select. You choose files and folders in the Google Drive picker window. In it you can see your entire Drive, but Mergado only gains access to the file or folder you select.
Supported files#
As an input feed, you can load from Drive:
- an XML, CSV, TSV, JSON, or JSONL file. Files may also be compressed in ZIP or GZ format,
- a Google Sheet.
How to load an input feed from Google Drive#
When creating a project (classic interface)#
The selected file serves as an ongoing data source. Mergado reloads it on every subsequent project update according to its settings.
- Start creating a project as described in How to create a new project in Mergado.
- In the Feed source step, click Use feed URL next to the product feed.
- On the Where do you want to load the feed from? screen, click Select on the Google Drive card.
- If you do not have a Google connection yet, click Connect Google Drive. Mergado Keychain opens — log in with your Google account. After connecting, you are taken back to the wizard. Below the cards you will see the email of the connected Google account with the status Connected.
- Click Select file from Google Drive. In the Select a file window, find the feed file (you can search within it) and click Select. The window mainly shows folders and supported file types, so if you cannot see a file, check its format.
- Mergado downloads and analyses the file just like a feed from a URL. Continue through the wizard.
When you return to the source step, you will see Selected file and can replace it by clicking Change file.
When creating a project in Canvas#
In the 1. Connect data source step, click Use feed from Google Drive and select the file. If you do not have a Google connection yet, there is a Connect Google Drive panel instead.
The source then appears in the project as Google Drive with the file format, for example Google Drive - CSV.
For an existing project#
You cannot yet select or change the Drive source file in Project settings.
How to upload the output feed to Google Drive#
After every export, Mergado uploads the output feed to the folder you choose and overwrites the same file each time, so its link remains valid. The file has the same name as the file in the output feed URL, which you can find in Project settings → Basic information. For example, for https://feeds.mergado.com/project-name-…xml the file is named project-name-…xml. The output feed URL continues to work — uploading to Drive is an additional option.
When creating a project (classic interface)#
On the last screen of the wizard, below the output feed URL, you will find the Additional options section. If you do not have a Google connection, click Connect Google Drive. If you do, click Upload file to Google Drive and select the target folder. After selecting, the confirmation Google Drive folder has been saved appears, along with the Upload output feed to Google Drive block showing the selected folder and the Change folder and Remove buttons.
When creating a project in Canvas#
In the Optional section, choose Export to Google Drive and select a folder. The folder is saved once the project is complete.
For an existing project#
In Project settings → Google Drive section (below the SFTP/FTP/FTPS server section), select the target folder. You can also change or remove it here.
The Remove button disables uploading for this project only. The Google connection in Mergado Keychain remains and can still be used.
What happens if you disconnect the Google connection#
The Google connection belongs to the online store. Disconnecting it in Mergado Keychain therefore affects all online store projects that use Google Drive:
- The input feed from Drive stops loading and the import ends with an error that you will see in the project history.
- The export completes, but the output feed is not uploaded to Drive and a warning appears in the export log. Drive uploading is disabled for the online store’s projects, and a record of this appears in the project and online store history. The target folders on Google Drive are not deleted. Mergado does not create or delete folders — it only uploads to them.
If you want to disable uploading for just one project, use the Remove button in its settings. Mergado also notifies you with an error or warning if you delete the source file or target folder, or if you remove Mergado’s permission in your Google account.
FAQ#
Do I need to share or publish the feed on Drive?#
No. Mergado accesses the file through your Google connection in Mergado Keychain. The file can remain private.
Can I use a Google Sheet as the source?#
Yes. You can select a Google Sheet from Drive the same way as any file. You do not need to publish it as CSV.
Can I select a file from a folder someone shared with me?#
Yes, as long as you have the necessary permissions for the file or folder (see What you will need). Shared drives are not supported yet.
Why is my Drive feed not offered among existing URLs?#
A feed connected via Google Drive is not offered among recent or existing URLs when creating additional projects. When creating a new project, select it from Drive again.
Where do I find the Google connection and how do I fix it?#
In Mergado Keychain. When selecting a file from Drive, the wizard shows the email of the connected Google account and its status. If the connection stops working, Mergado will offer Reconnect with a link to Keychain.