Rules for transferring data to Google Sheets

to transfer data to google sheets certain rules have to be followed, otherwise, correct transfer of data is not guaranteed data may be trickled over, placed in the top row, or not transferred at all in the sheet where data is transferred, it is forbidden using filters on columns using formulas in column a or others where data is transferred if columns a to d are being filled in, formulas can be used in row e hide rows or columns rename the sheet if renamed, the automation will continue to work only after updating the data in the connection specify punctuation marks in the sheet name, the name must consist strictly of letters and/or numbers to protect a specific range of cells, that is, to disable editing delete the entire row that has already been filled in using albato if you want to delete it, fill in the cells with dashes delete headers — 1st line you can rename it, but if you delete column a in the 1st row, the data will stop coming in fill in any row yourself, except for the last free one this means that if you have rows 1 through 20 filled in, you can only fill in row 21 yourself if you fill in the 22nd and beyond, stable data transmission will stop transfer data to a single sheet using different bundles for each source, you need to make your sheet also, follow the rules of layout before creating any automation, you must fill in the 1st row yourself, that is, make a «header» column a should be filled out, always write in the column a header never leave it empty in particular, in the automation itself, column a must be filled in if there is already some data in the sheet, all rows must be filled in it is not allowed to fill in rows from 1st to 5th, then from 7th to 10th row 6 cannot remain empty to transfer data, you must have a purely «technical sheet» it should look something like this this option is not allowed if you still need to use filters, formulas, and so on, create two sheets in the table «technical» first sheet — albato sends data to it in the second sheet, use the formula =importrange thus, you will have one simple sheet where data is transmitted and a second sheet where all information is duplicated in real time, where you can also configure formulas, filters, and so on on the second sheet, write this formula under each column in the 1st row the formula is filled in like this =importrange («table reference»; «sheet name! cell range»)