1. Go to settings
To insert images in cells to to the settings tab and select the Image in cell option. Enter one at a time the width and height of your cells.
2. Sharing with access permissions rules
If you want to share the sheet with other set the appropriate permissions.
You can share some files with one type of access and others with a different type of access.
The access setting must be set before you insert/add files to your Sheets. The default setting is PRIVATE.
The options from the most secure to the less secure:
PRIVATE – Only people explicitly granted permission can access the files inserted with FileDrop.
DOMAIN WITH LINK – People in your domain who have the link can access. Not for users with @gmail.com.
DOMAIN – People in your domain (email@domain.com) can access. Not for users with @gmail.com.
ANYONE WITH LINK – Anyone who has the link can access. For any type of Google emails or Workspace accounts.
ANYONE – Anyone can access. For any type of Google emails or Workspace accounts.