↑↓ selectEnter openEsc close

    1. Elbuz

    How to receive a supplier price list by link

    10 min readUpdated

    Elbuz downloads the price list from the supplier's address on every source import: direct link, Google Sheets, cloud storage or supplier account.

    When you need this:

    • Price list in Google Sheets — paste the address as is; the program exports the workbook to xlsx.
    • Private spreadsheet — the supplier shares it with the Elbuz service email, no password needed.
    • New date in the file name daily — a date template in the link; the program checks up to five days back.
    • Price list behind a login — the program signs in to the supplier account.

    Where to start: source card → “Source” section → “URL” tile → “File URL” field.

    What importing by link can do

    How to connect a price list by link

    The most common automatic method. The supplier posts the file on their site or in the cloud and gives you the address — the program downloads it by itself every time.

    The “URL” method fields in the “Source” section are saved automatically; there's no separate save button for them.

    FieldWhat to enter
    “File URL”the address where the price list is
    “Login”the user name if the file is protected by HTTP authentication
    “Password”the password for it
    “HTTP request headers”an access key if the supplier requires it in a header
    “Private Google file (access via service email)”a checkbox for a non-public Google file

    The login and password are sent as regular HTTP authentication. One exception: if the supplier account login form is filled in for this source, the same login and password go into the form instead of the authorization header.

    Request headers

    The “HTTP request headers” field is needed when the supplier issued an access key and requires it in the request. The hint under the field says, word for word: “Optional. One header per line in “Key: Value” format. For example, if the supplier requires an access key: X-API-Key: your_key or Authorization: Bearer your_token”.

    Stick to the format exactly: the program silently drops a line without a colon. There's no warning — the header just isn't sent, and the supplier refuses the request. You can add as many headers as you like, one per line; they're added to the ones the program always sends.

    This is rarely used. But when the supplier gives out the price list only with a key, there's no other way.

    How to get a price list from Google Sheets or cloud storage

    Suppliers don't always give a direct link to the file: often it's the address of a page in cloud storage. Paste the link the supplier gave you — the program turns links from three services into a direct download itself.

    ServiceWhat the program does
    Google Sheetsremoves extra tails from the address and adds export in xlsx format
    Google Driveturns the file view address into a download address
    OneDrivereplaces the view page with the download page

    A Google Sheets workbook is always exported as a whole. The sheet number is removed from the address, so you can't pick a sheet with the link — even if the supplier gave an address with the right sheet open. You choose the sheet in the source card, with the “Import from sheets” link in the header of the “Columns” section.

    Private Google file

    When the supplier doesn't want to make the spreadsheet public, they can share it with one specific email. That's what the “Private Google file (access via service email)” checkbox is for. Under it, a hint with the address opens: “The Google Sheets/Docs file is not published and is shared with a specific email. Open the file in Google → “Share” → add the service email below with “Viewer” permission. After that Elbuz will download the file automatically.”

    The program then gets the file not as an anonymous visitor but on behalf of the Elbuz service account, and it doesn't need your Google password for this. A native Google spreadsheet is exported to xlsx.

    The checkbox works only for Google Sheets and Google Drive addresses. For a file in other storage it changes nothing.

    Source section of a link-based price list: File URL, Login, Password, HTTP request headers and the Private Google file checkbox
    1File URL
    2HTTP request headers
    3Private Google file
    1. File URL — the link to the price list, here a Google Sheets address.
    2. HTTP request headers — extra headers sent with the request, such as an API key.
    3. Private Google file — the checkbox for a file shared with the service email; left off here.

    How to get a file whose name has a new date every day

    Some suppliers post a new file every day with the date in its name: “price_16.08.2026.xlsx”, “Pricelist 16.08.2026.xls”. The address changes daily, so a fixed link won't help.

    For this, put a date macro in the link: {get_date("d.m.Y")}. It's replaced with the current date in the given format, using the usual date notation: d — day, m — month, Y — four-digit year. The quotes inside the brackets are optional; the result is the same. A second, different macro in the same field isn't filled in — the program takes only the first one.

    First the program fills in today's date and checks whether there's a file at that address. If not, it goes through the previous days, up to five days back, and takes the first one found. So after a weekend or a supplier glitch the price list still arrives, just not the freshest one. If none of the six options works, the log gets “Failed to get file link!” — the download attempt ends there, and the run continues with yesterday's file.

    The date steps back from today until the server stops answering 404. Six misses in a row — and this time the link gives no new file
    NoYesNoYesNoYes“URL” methodDoes the link havea date macro?File is downloadedfrom this addressToday's dateis filled inDid the server answerwith code 404?Already checkedfive days back?The date one dayearlier is filled in“Failed to get file link!”no new file by link
    • Action or result
    • Decision: the path depends on the answer

    While going through dates, the only check is whether the server answered 404. A placeholder page with code 200 or a 403 refusal means “the file exists”, and the program stops at that date. What actually came shows after the download: “The supplier site responded with code 403 — …” for a refusal, “The link returned a web page instead of a price list file…” for a login or error page. If the log shows either and the link looks right, open it in a private browser window: you'll likely see a login or error page, not the file.

    How to get a price list from the supplier account

    A harder case: the price list is in the supplier account and isn't visible without signing in. There's a separate window for this — “Supplier account login settings”; it opens with a link in the “Source” section when the “URL” method is selected.

    In it you enter not the login and password but the names of the login form fields on the supplier site; the login and password come from the “URL” method fields, and sign-in happens only when all five are filled in. The log shows this as the line “Signing in to the supplier account”. There are also fields for harder sites — security tokens and a selector, if the price list link first has to be found on a page.

    Once set up, the program signs in to the account with the supplier login and downloads the price list — on the source schedule or with the import button, like any link. The window fields:

    • “Login page URL” — the address of the page where the browser shows the login form. The “Get a list of fields” button at the bottom of the window loads this page and shows its form fields — take the names for the fields below from this list.
    • “Form submission URL” — the address the form sends the login and password to. If empty, the program submits the form to the login page.
    • “Field name: login” and “Field name: password” — the names (the name attribute) of the form fields, not the login and password themselves.
    • “Field name: csrf token #1” and “#2” — if the form has a security token: the program opens the login page, takes the value of the field with this name and sends it along with the login.
    • “Link to the page with the link to the price list” and “CSS selector to get the price list link” — when the file address in the account changes every time: after signing in, the program opens this page and takes the link from the element the selector finds.
    • “List of input values to pass manually” — extra form fields, one per line as name = input_name, value = input_value.
    Window «Supplier account login settings» with empty fields for the login page, form fields and CSS selector
    1Login page URL
    2Field name: login / password
    3CSS selector for the price list link
    4Get a list of fields
    1. Login page URL — the page of the supplier site with the sign-in form.
    2. Field name: login and Field name: password — names of the form inputs for sign-in.
    3. CSS selector to get the price list link — where on the page after sign-in the price list link is found.
    4. Get a list of fields — reads the form fields from the site; not pressed here.

    This is a job for someone who can read another site's page code. If that's your case, it's easier to first ask the supplier for a or access.

    Scenarios

    The supplier posts a new file with the date in its name every day

    What to do. In the “Source” section, select the “URL” tile and paste yesterday's file address into “File URL”, replacing the date with the macro: {get_date("d.m.Y")} if the file is named “price_16.08.2026.xlsx”. The format inside the brackets must match how the supplier writes the date in the name.

    What you get. Each run fills in today's date; if the server answers 404 for it — yesterday's, and so on, up to five days back. On a weekend when the supplier posted nothing, Friday's file is picked up.

    What won't happen. A file older than five days won't be found — you get “Failed to get file link!” and a run on the previous file. Going through dates stops at the first address where the site answered anything but 404. If that's a login page or another error code, not the file, the log shows “The link returned a web page instead of a price list file…” or “The supplier site responded with code …”, and the run uses the previous file.

    The supplier doesn't want to make the Google spreadsheet public

    What to do. The “URL” tile, the spreadsheet address in “File URL”, the “Private Google file (access via service email)” checkbox. Give the supplier the service email from the hint under the checkbox: they add it in the file's “Share” settings with “Viewer” permission.

    What you get. The program gets the spreadsheet on behalf of the Elbuz service account, without your Google password, and exports it to xlsx.

    What won't happen. You can't pick a sheet with the link — the whole workbook arrives; the sheet is set in the “Columns” section via “Import from sheets”. The checkbox doesn't work for a Google document or presentation, or for files outside Google Sheets and Google Drive.

    What to do when the file doesn't arrive by link

    Common problems
    What you seeWhyWhat to do
    “Failed to get file link!” The link has a date macro, and for none of the six dates — today and the five previous days — did the server return a file (only code 404 is checked). Without a date macro this message doesn't appear Open the address with the date filled in in a browser and compare the date format with how the supplier names the files (about the date in the link)
    “The supplier site showed a browser check (Cloudflare) instead of the file…” The site is protected by a check that only a browser passes, and the program downloads the file without a browser Ask for a direct link without protection or an exception for our server; otherwise, email or FTP (causes in the log)
    “The link returned a web page instead of a price list file…” or “The supplier site responded with code ‹code› — …” The site returned a login or error page, or refused with a code: 403 — no access, 404 — no such file, 429 — too many requests, 5xx — server failure Open the link in a private browser window and check the address and the key in it with the supplier; 429 and 5xx usually clear up by the next run (about the link)
    “The service account has no access to the file. Share the Google file with the email: ‹address› (Viewer permission).” The private Google file checkbox is on, but the has no access to the file Open the file in Google → “Share” → add the address shown with “Viewer” permission (about private files)
    “Access to private Google files is not configured on the platform. Please contact support.” The platform has no service account key Contact support — you can't set this up yourself (about private files)
    “This Google document type is not supported for price import. Use Google Sheets.” The link points to a Google document or presentation, not a spreadsheet Ask the supplier for a Google Sheets spreadsheet specifically (about private files)
    “Could not recognize the Google link. Please check the file link.” The file ID couldn't be extracted from the address Copy the link again from the address bar of the open file (about private files)
    “Error while downloading the file from Google.” Another Google error; details are appended to the text Run the import again; if it repeats, contact support (about private files)

    FAQ

    The link opens in a browser, but the program doesn't see the file. Why?

    The site gives the program a page — a login, a browser check or an error. What exactly came is written in the source log as a red line. Open the address in a private browser window and compare — troubleshooting.

    The supplier requires an access key. Where do I enter it?

    In the “HTTP request headers” field, one header per line in “Key: Value” format, for example X-API-Key: your_key. The program silently skips a line without a colon — about headers.

    How do I choose the right sheet of a Google spreadsheet?

    Not with the link: Google Sheets always exports the whole workbook. You choose the sheet in the source card, with the “Import from sheets” link in the header of the “Columns” section.

    Does the program need my Google password for a private spreadsheet?

    No. The supplier shares the file with the Elbuz service email with “Viewer” permission, and you turn on the “Private Google file” checkbox — about private files.

    The price list is in a supplier account behind a login. Can the program sign in by itself?

    Yes, on the source schedule, like a regular link. The login and password go into the “URL” method fields, and the form field names — into “Supplier account login settings”. Sites with a CAPTCHA won't open this way — about the supplier account.

    Where it is and who has access

    Menu
    Directories → Processing price lists → List of price lists
    Source card
    the “Source” section → the “URL” tile
    Supplier account
    the “Source” section, the “URL” method → “Supplier account login settings”
    Access right
    the “List of price lists” window plus “Import settings” and “…price list file”
    Prepare
    the file address; a login and password or an access key if the file is private

    Why a source should have only one method set up — see the article on ways to receive a price list.

    Related topics

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free