I have an airtable table that I have automated into a Google sheets sheet, and then have that google sheets sheet copying info to another google sheet using the =Sheetname!cell number formula, but nothing appears when I have the airtable automated data in there, only when I type it manually into the google sheet. How can I fix this? is the data formatted differently when it comes from Airtable, or does the google sheet not recognize it is there or something in order to add it to the second sheet?
If your google sheet forumla is referencing a specific cell; check if the cell reference is changing when a new row from airtable is added.
I know most apps when they add a row of data to google sheets do it by effectively ‘inserting’ a new row; pushing all the existing cells (and cell references) down by one row.
If you are trying to copy/link/sync all the data from one google sheet to another; look into using the “IMPORTRANGE” function instead.