I am trying to set up a system for clients where data I input into a Google Sheet is automatically pulled into a Google Doc, but am having trouble.
The sheet would be something like: Column A: Name, Column B: Address, Column C: Email, Column Notes with rows of data for different names and info.
The google doc would, in theory, have all the records in the sheet in a single file with updated fields correlated to the rows in the sheet.