Skip to main content

Remove (Google Sheet) Mutation

The Remove (Google Sheet) mutation allows you to eliminate specific portions of a value in a product field based on Google Sheet. This is useful for cleaning up your data or focusing on essential details. The Google Sheet must contain only one column with the value to remove.

A screenshot showing the remove Google Sheet.
Remove Google Sheet Example

Options​

  • Google Sheet ID: Unique identifier for the Google Sheet.
  • GID: Unique identifier for the sheet within the Google Sheet. If the Google Sheet only contains one sheet, the GID is 0. It's only nessesary to change the GID if the Google Sheet contains multiple sheets. Set the GID to 0 to use the first sheet.
  • Remove multiple: Whether to remove multiple values or only the first one found.
A screenshot showing the remove (Google Sheet) mutation.
Remove (Google Sheet) mutation example

Google Sheet format​

  • The Google Sheet is required to only have only one column with the value to remove.
  • The value to remove is case sensitive.

Connecting Google Sheet​

Firstly, make the Google Sheet accessible to anyone with the link. Otherwise, we can't read the data in the sheet. To do that, click the Share button in the top right corner of the Google Sheet and change the general access to Anyone with the link like shown in the image below.

A screenshot showing how to change Google Sheet accessibility.
Change Google Sheet accessibility to anyone with the link.

Now, we need to get the Google Sheet ID and GID. To do that, open the Google Sheet and copy the Google Sheet ID from the URL. The URL should look something like this:

https://docs.google.com/spreadsheets/d/19NIOMFcWW5y0boWh8MbD-VAHNMgjvWDXl3y5sMBABKg/edit#gid=0

For this example, the Google Sheet ID is 19NIOMFcWW5y0boWh8MbD-VAHNMgjvWDXl3y5sMBABKg and the GID is 0. If your sheet has multiple sheets, the GID will be different.

You can check if everything is working correctly, by clicking the Test connection button on the mutation.