I have a Google Spreadsheet here - [login to view URL]
Looking to get a script written which:
1. grabs the information on the 'Input' sheet
2. matches the client-name from 'Input' sheet with the client-name in 'Client-Info' sheet and the other client information in the row.
3. Posts data from step 1 and 2 into the 'GMB Posts' sheet
I have manually copied the first post's example into the 'GMB Posts' sheet for reference.
The data should validate the 'GMB Posts' sheet's cells.
For the final version, there will be a few hundred clients so your script should be able to support scaling.